Posts by luisgiraldo89

Hi Guys,

Hope all are well. Just a general question, anyway to create a macro to insert a 3D model (.stp, parasolid, STL, etc..) inside excel?

Thanks

Re: Lock row after pressing save

Hi Max,

The solution did seem to work. Also sorry for the late response. I found a solution it worked pretty well. I just inserted this into my code

Sheet1.Protect Password:="password", UserInterFaceOnly:=True
'enter code
Sheet1.Cells(1, 1) = UCase("")

Hi Guys,

Looking for some vba help.

I have a spreadsheet columns A-M and rows 10-200. I would like the user to input all data lets say in row 10 than save and lock that row and so on. I need it to leave other rows unlocked.

For example:

User 1 puts data in row 10 -saves -locked
user 2 puts data in row 11 -saves-locked

when i open up the work book row 10 and row 11 will be locked the rows 12-200 are unlocked.

if user 3 uses row 12 saved next time i open the workbook row 13-200 are unlocked and so on.

Re: CHANGE BACKGROUND COLOR and FONT ON ALL SHEETS

Hi roy,

Great job for simplifying. Your website looks great, very informative got a little bit of time to check it out. Both of you guys thanks again. Anywhere i can donate to this site?

Re: CHANGE BACKGROUND COLOR and FONT ON ALL SHEETS

Perfection! Thank You!

Hi Guys,

I am looking for a vba code that will change my background color to "white" and font to calibri 11 from columns A-Z and rows 1-100. I want this code to do this on every sheet on the workbook. Not sure but do the sheet names matter?

Thank You

Re: Copy columns to different sheets

mrmmickle1 you are the man! Thank you for your support!

Re: Copy columns to different sheets

Hi mrmmickle1,

loooks good almost what i wanted. When i run the code it makes 2 sheets one with 1 table which is what i wanted and another sheet with the left over tables. Anyway to make it so that it populates 1 sheet with 1 table?

Thanks for the quick response!

Hi,

This may not be complicated but after i read some of the forums, i have not found a solution. My problem is i have all my information on one sheet. My sheet has 3 columns of data, on column A it specifies a table (table 2, 3, 4, 5, etc...). Each Table has data below. What i am looking for is for each table and the data below the table to be in a different sheet. So if i have 20 tables, i will have 20 sheets. Would really appreciate the help?!!!

Re: VBA to enter value of one cell into corresponding cells in the same worksheet

Quote from Raha;769536

See if this works for you...

Code

Sub Test()
    Dim SL As Object, A As Variant, i As Long
    
    Set SL = CreateObject("system.collections.sortedlist")
    With Sheets("Sandvik US Price List").Cells(1).CurrentRegion
        A = .Value
        For i = 2 To UBound(A, 1)
            If Not SL.contains(A(i, 1)) Then
                SL.Item(A(i, 1)) = VBA.Array(A(i, 2), A(i, 3))
            End If
        Next
    End With
    
    With Sheets("Sheet2").Cells(12, 1).CurrentRegion
        A = .Value
        .ClearContents
        For i = 2 To UBound(A, 1)
            If SL.contains(A(i, 2)) Then
                A(i, 4) = SL(A(i, 2))(0): A(i, 5) = SL(A(i, 2))(1)
            Else
                A(i, 5) = "For quotation"
            End If
        Next
        .Value = A
    End With
End Sub

Display More

*Or Can we do the same code for different spreadsheets? I will be adding new sheets all the prices will be updating from the same list. See attached spreadsheet i added sheet3 with new products. Can we do the same in sheet2 as in sheet3 and sheet 4,5,6 in the future?

Thank You for your help.forum.ozgrid.com/index.php?attachment/68906/

Re: VBA to enter value of one cell into corresponding cells in the same worksheet

It looks good. Looks like the values are populating from the Sandvik US price list which is fine. I think what i really wanted to achieve in worksheet 2 is to use the search button look for the item in the Sandvik US price list and have the price show in the table. The reason for this is that it will only show the prices for the items that the customer want. Let me know if there is anything else we can do?

Thank You

Hello Guys,

I just started with VBA so i am no expert. So basically i am trying to do is have a vba code that will take cell "A38" match that cell(item Code) with column(Item Code) "B13:B28" and than once it finds the matching cell record the cell value (price) on "C38" with the corresponding column (price) "E13:E28" if no value to say "for quotation". I attached a sample worksheet so you can see what i mean.

forum.ozgrid.com/index.php?attachment/68902/forum.ozgrid.com/index.php?attachment/68902/