linking value from one excel file to another Closed

Question

Hello,
I have a small business (small convenience store) and wants to use excel to keep track of my sales and inventory on a daily basis. I made a simple one where in it shows my beg and ending inventory for the day including sales receipts. However as I want a daily report. I wonder how would I link the ending inventory on an existing file to another file wherein it automatically goes to the beginning inventory for the next day without having to input the figures again. I know this may sound too easy for some but as I am not really an excel user. I could only do the basics. Can anyone help me please thanks. i basically want to link the values of today's ending inventory to tomorrow's beginning inventory without inputting the formula everyday to save time. I know nothing about macros however willing to learn if someone could provide me some tips thanks

Trowa · Answer

Hi Sanbeda,

If you want to link the data from one file to another file, open both files.
In file 2 select a cell in which you want the result.
Now put your cursor in the formulabar and type "=".
Now select the cell in file 1 that you want to link and hit enter.

Hope this helps.

Best regards,
Trowa

strnnger · Answer

hi there,

follow these steps and try :

1. Go to Start>Programs>Microsoft office>Microsoft Excel to open the application. Then, go to Start>New to open a new spreadsheet. Go to File>Save as and save the new file before going further so you dont loose any work.

2. Go to Tools>Macro>Security, and a pop up window named security will appear. Select the Medium option under the Security Level tab and click OK to continue.

3. Go to Tools>Macro>Record New Macro.

Thanks

Linking value from one excel file to another

2 responses

Subscribe To Our Newsletter!