I have a real head scratcher that I can't seem to get past and could use some assistance.
I have a spreadsheet that needs to be populated daily based on varying data (i.e. some days row 6, 8, &, 10 are populated and other days rows 1, 5, 9, & 11 are populated)
Currently I have a VLOOKUP (linked to a secondary document) in every cell (A1:AV54) that will return a blank if the beginning of that row is not populated on that given day, however that is causing the document and my computer to run slow and even sometimes crash.
I need HELP!
I am thinking one of two solutions will work but I am unsure on how to write either
1. Is there a VBA macro that will search column B for data and then enter the VLookup on only those corresponding rows in Column C?
2. Can I filter the data and then apply the vlookup to the top row (varries) and then copy down to the end of the filtered data?
Any help or guidance would be greatly appreciated.
Have a great week!
I have a spreadsheet that needs to be populated daily based on varying data (i.e. some days row 6, 8, &, 10 are populated and other days rows 1, 5, 9, & 11 are populated)
Currently I have a VLOOKUP (linked to a secondary document) in every cell (A1:AV54) that will return a blank if the beginning of that row is not populated on that given day, however that is causing the document and my computer to run slow and even sometimes crash.
I need HELP!
I am thinking one of two solutions will work but I am unsure on how to write either
1. Is there a VBA macro that will search column B for data and then enter the VLookup on only those corresponding rows in Column C?
2. Can I filter the data and then apply the vlookup to the top row (varries) and then copy down to the end of the filtered data?
Any help or guidance would be greatly appreciated.
Have a great week!