Excel question

Closed
Jayne - Jun 6, 2011 at 12:38 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 6, 2011 at 01:36 PM
Hello,
I am using Excel for inventory and invoicing. They are in different workbooks.
I have to fill in the information in each workbook. My question is: Is there a way to fill in one workbook and have the information automatically transfered to the other?
Please help this non profit save some time. Thank you in advance for any suggestions.


1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jun 6, 2011 at 01:36 PM
Hard to give you any suggestion without looking how things are. Very vague idea includes, you can link workbooks or worksheets (what ever the case may be), Have a macro do it etc
0