Entering data on 2 excel sheets at the same time.

[RLJCook]

I have an excell file that tracks orders. The first sheet is like a checkbook and keeps a running tabulation of the cost of all the orders. The File also has many pages with customers on them. The data has to be entered on the running tabulation page then on the customers page. Is there a way that enter the data onnthe running tabulation page will also enter it on the customer page?

 

[miss_ell]

Hello RLJCook

I know of two ways to do this. If the two columns where the information is to be entered on each page are identical, then just select both pages at once (while you're in the running tabulation page, hold the Shift key and click on the tab in the customers page) then just enter the data as normal and the figures will automatically be copied onto the other sheet. But remember to unselect the sheet as soon as you're finished!!

The second method is to enter a formula in the second sheet such as =A1 and copy the formula down the column.

Hope this helps!!

miss_ell