Forum Discussion
VBA to append multiple columns to last column across multiple worksheets
Hello, I'm looking for VBA code to perform a manual task to reduce risk of copy/paste errors. I have a Workbook with the following Worksheets: Starting with the 'main diagnoses' Worksheet...
What should the code look up in that lookup table?
Hi Hans,
The Lookup Table provides 2 things:
1) The 1st row of the Lookup Table provides the Column Names to be appended to the dataset in the Worksheet
2) The 2nd row of the Lookup Table provides the first row of values that would then be essentially copied down the remaining rows of the dataset on that Worksheet
Please let me know if I've answered your question properly - thank you!