Forum Discussion
Solved
Finding a way to generate "report" exports (PDF) down a list of ID's
So I've provided dummy data to help explain my case. My real data has 200+ rows of employee salary info. There are two sheets: "Report" and "Data" The report values are populated by VLOOKUP based o...
See the attached version. It is a macro-enabled workbook so you'll have to allow macros when you open it.
Do I step into the macro, copy-paste into my full dataset and change cell/sheet values?
Open both your 'real' workbook and the workbook that I posted.
Press Alt+F11 to activate the Visual Basic Editor.
Drag Module1 from the latter to your real workbook. This copies the module with the code.
Double-click Module1 under your workbook, and edit the references to sheets and ranges as needed.
Then switch back to Excel and save your workbook as a macro-enabled workbook (.xlsm)