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 Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

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.
 

Forum statistics

Threads
1,181,613
Messages
5,930,927
Members
436,767
Latest member
Langaws

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