dwilson38550m
Board Regular
- Joined
- Nov 21, 2005
- Messages
- 89
Hi,
Sorry I hope this in easy one...I am copying data from one source to a master workbook (Sheet1). Is there a way I can use a vba to paste special values data into the next available free/empty cell in the master workbook Sheet1. For day 1 the data i copy in may be 10 rows (cell A1 to A10), the next day it may be 15 rows of days (A1 to A15), day 3 25 rows of data (cell A1 to A25) etc. I just don't know how to automatically find and paste special values to the next free cell in the master workbook (Sheet1). Thanks in advance.
David
Sorry I hope this in easy one...I am copying data from one source to a master workbook (Sheet1). Is there a way I can use a vba to paste special values data into the next available free/empty cell in the master workbook Sheet1. For day 1 the data i copy in may be 10 rows (cell A1 to A10), the next day it may be 15 rows of days (A1 to A15), day 3 25 rows of data (cell A1 to A25) etc. I just don't know how to automatically find and paste special values to the next free cell in the master workbook (Sheet1). Thanks in advance.
David