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

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

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,147,686
Messages
5,742,623
Members
423,744
Latest member
bkirtland

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