Posts by zuko

    I have an excel file with about 50-60 workbooks inside of it each containing data.

    I work for Albertsons and each tab is an individual store

    For example:

    One store (tab) might say

    Crackers 4ft

    Another store (tab) might say

    Crackers 12ft

    I want to go across workbooks and have it count how many stores use the 4ft set and how many use the 12ft set. I'm not sure if this is possible or how to even go about doing it. Any help would be much appreciated. Thank you.

    This is what I have for my code

    If Cells(row, 3).Value = "=search(""private"",descript)" = 1 Then Rows(row).Interior.ColorIndex = xlNone

    Looking at this part specifically. What I want the code to do is look in column 3 of the worksheet for every instance of word "private" and when it finds it, I want it to shade that whole row clear.

    Any ideas? Thanks a lot for the help.

    Below is the code I currently have which will open workbooks Run my macro then save them into the same folder and go onto the next workbook.

    Sub DBSSReport()
    sFileName = Dir("P:\SMARTeam\SMARTeam Files\Rankings\DBSS Files\Macro Ready\" & "*.xls")
    Do While sFileName <> ""
        Set Wkb = Workbooks.Open("P:\SMARTeam\SMARTeam Files\Rankings\DBSS Files\Macro Ready\" & sFileName)
        Call MainBeast
    Wkb.Close (True)
    sFileName = Dir
    End Sub

    What I need is to open a workbook from the above folder then save to a different folder with the path of P:\SMARTeam\SMARTeam Files\Rankings\DBSS Files\Final
    Any Suggestions?

    Re: Vlookup using VBA

    I must have missed your last post for some reason. I got it to work, thank you very much. One additional question though.

    In your code

    Everything works but when I do an autofill to go down it takes forever to calculate all those cells. Is there a faster way around it by chance? Way to just paste the values? Thanks!

    I posted this topic before but no responses seemed to help. I will try a different approach to it.

    Below are the values that need to be imported into the next sheet (picture2) referenced through UPC.

    [Blocked Image:]

    [Blocked Image:]

    I need to be able to do this for multiple workbooks therefore needs to be written in VBA and ran by the macro. Is it possible to put the data into an array and use vlookup to return only the result of the vlookup into the sheet (picture 2).

    It is really difficult to explain this in text, so if anyone needs more clarification, please let me know. Thank you all in advance.

    I need help with making vlookup go all the way across my columns and down. Is it possible to have lookup_value and column_index both be variable values? If it isn't possible, is there another way this can be done?

    As of right now, I got the vlook up to go across, but the the cell value stays the same all the way across, I would need it to change going from one column to another, if this makes sense.

    [Blocked Image:]