Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
macro for copying raws of data
Name: chamaka Date: March 20, 2009 at 04:25:54 Pacific OS: Windows 2000 Subcategory: Microsoft Office
Comment:
Hello, I would like to write a macro to copy a several raws of data in to a another excel work book. for eg, todays sales figures (only 5 rows from a spreadsheet of about 30) to go in to another work book so tomorrow when i run the macro it should populate the other workbook to the next row. Is this possible, hope someone could help
Summary: I need to create a macro for excel that copies data in specific cells in Sheet1 to the next empty column in Sheet2. The data I am copying is coming from a web query that updates every hour, so I woul...
Summary: re: This is intended to be a regular process until we get proper reporting stood up; Then we are going to need some more detail. We would need to know what ranges need to be copied and where they need...
Summary: I have been looking at it too. I am on Excel97 and can not apply the 'Relative Reference' to my macros like I could with Excel2K. It continues to input the actual cell ranges. I can make my macro work...
