Excel question

Closed
Jayne - 6 Jun 2011 à 12:38
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 6 Jun 2011 à 13:36
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.


Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
6 Jun 2011 à 13:36
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