Transferring data from on excel spreadsheet to another
Hi,
I have one spreadsheet with many columns where users enter data for historical and reporting purposes. I have another spreadsheet where one complete record is shown (one row in the first spreadsheet), i.e. an order form, or an approval form. What I need to do is automate the data transfer between the first and second spreadsheet. So that the user doesn't have to enter the same data twice. In other words, when the user enters a row of data in the first spreadsheet, a macro (or something else???) takes the data and transfers it to the correct cells in the second spreadsheet (the approval form). Is this possible in excel? |
All times are GMT +1. The time now is 02:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com