Easy question, please help

bugslife

New Member
Joined
Jan 27, 2005
Messages
6
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 :)
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

tmischler

Well-known Member
Joined
Jun 17, 2004
Messages
669
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.
 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,611
Messages
5,765,415
Members
425,286
Latest member
CazzaBabes

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top