PDA

View Full Version : VBA to load specific cells from one doc to another



Marine2149
08-26-2019, 03:59 PM
Hello, I am new so bare with me.

I have a document that has many Pivot tables pulling from one table in my document. Right now I download the report and copy cells A5 to M5 and down to the last bit of data. It can change from 20 cells down to 200 or more. So I need it to be able to change with the input. What I would like to do is assign a macro to a button on the workbook and then a pop up window appears and you select your report from where ever on yourcomputer. It will extract the data fromCell A5-M5 and all the way down and paste it into my table called “CAL”. If the VBA could be easily changeable so I canchange the cell range across and the table it pastes to. If anyone could help me with this I wouldtruly appreciate it!