Hello Guys,
Currently, I download raw data into a worksheet tab (Sheet1), then use the advance filter to filter out the information I need and spit it out onto another worksheet tab in the same workbook (Sheet3). This output is dynamic and changes all the time in terms of the number of rows.
I have a template saved on the network, which I open up, clear the numerical values (not the headers), and paste in the item numbers, description, etc... into the template. Is there a more efficent way of doing this other then pasting the item numbers into my template, and then doing a vlookup for the other info I require for the rest of the columns?
Thanks in advance
Currently, I download raw data into a worksheet tab (Sheet1), then use the advance filter to filter out the information I need and spit it out onto another worksheet tab in the same workbook (Sheet3). This output is dynamic and changes all the time in terms of the number of rows.
I have a template saved on the network, which I open up, clear the numerical values (not the headers), and paste in the item numbers, description, etc... into the template. Is there a more efficent way of doing this other then pasting the item numbers into my template, and then doing a vlookup for the other info I require for the rest of the columns?
Thanks in advance
