sanilmathews
Board Regular
- Joined
- Jun 28, 2011
- Messages
- 102
Hi All,
I would need some help in getting VBA code for copy and pasting a tabular data (range varies - excluding headers in row 1) in a worksheet named "comm log" of a different workbook to the master workbook (macro enabled). Would like to pick the file using msoFileDialogFolderPicker.
Code would enable user to copy paste worksheets at any point of time which will have the tabular data in a tab named "comm log". However for each instance the code should find the last updated line in the master workbook and start pasting it in the next available blank row (excluding headers).
Thanks in advance
I would need some help in getting VBA code for copy and pasting a tabular data (range varies - excluding headers in row 1) in a worksheet named "comm log" of a different workbook to the master workbook (macro enabled). Would like to pick the file using msoFileDialogFolderPicker.
Code would enable user to copy paste worksheets at any point of time which will have the tabular data in a tab named "comm log". However for each instance the code should find the last updated line in the master workbook and start pasting it in the next available blank row (excluding headers).
Thanks in advance