Viking1221
New Member
- Joined
- May 25, 2017
- Messages
- 32
Hello all,
I am looking for some assistance with a complex macro. I need to pull in all data in tabs between 'Start' and 'End' in my workbook into one tab called 'journals'. The trick is, I need to pull in all the data from each tab in columns JK:MX. Then I need to stack the data so tab 1 would have its data copied over as values, then tab2's data would be paste under it and so forth. "Start" and "End" tabs are blank if that makes it easier. After all the data is pasted I would need to removed all lines with all zero's from the 'journals' tab.
Can this be done?
Thanks in advance.
I am looking for some assistance with a complex macro. I need to pull in all data in tabs between 'Start' and 'End' in my workbook into one tab called 'journals'. The trick is, I need to pull in all the data from each tab in columns JK:MX. Then I need to stack the data so tab 1 would have its data copied over as values, then tab2's data would be paste under it and so forth. "Start" and "End" tabs are blank if that makes it easier. After all the data is pasted I would need to removed all lines with all zero's from the 'journals' tab.
Can this be done?
Thanks in advance.