Easy question, please help

[bugslife]

Hey everyone,

Ok heres an easy question for you experts but im an excel noob so im needing some excel love basically i have 4 invoice's on 4 different sheets. One is in AUD and another in USD ect... I have them set up so any amounts entered on the first form automatically carries over to the other 3 forms and does a currency conversion. What im having problems with is , i want to be able to enter the products and descriptions (in the products and description fields) and have them automatically fill in the correct cells on the other invoice sheets. So basically all i am doing in filling in one invoice and the rest are just duplicates. Doing this with numbers was easy, but i can seem to do it with text
Please help

 

[tmischler]

I don't see why you can't do the same with text (without the conversion of course).

1. just go to say your AUD sheet in the column you want the text to be entered.

2. Select the first cell you want data to go to and type = into it

3. Click onto your source tab and the corresponding cell

4. Press the F4 button until you can see no dollar signs in the formula bar

5. Press enter

6. Click on the bottom corner of the cell you have just populated in the AUD sheet and drag it down so that all the cells below are populated too.