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?