PDA

View Full Version : Replicating Text in Excel Sheets



caffy
12-03-2012, 02:56 PM
Hi,

I will be collating orders for tshirts for an event soon. On one Excel sheet, I will have the people's name in one column, with the following columns having their specific orders, such as tshirt design / size / colour etc.

What I want to do, is have another sheet (in the same Excel document), with the person's name in one column, then the next column has their address (for distribution).

I would like to set Excel to replicate - every time I update the orders - the Names from the first worksheet, into the second worksheet, when I have entered it. Then I just need to switch to the next sheet and enter the addresses, as their names would already be there.

I have looked at Google:
http://office.microsoft.com/en-us/support/5-tips-for-working-with-multiple-worksheets-in-excel-HA001042919.aspx The first tip was helpful, but that only works if the data are in the exact same columns - and the way my document is set up, the headers in each sheet are in different columns.

However, found this video http://www.youtube.com/watch?v=BdG43GjIwRg which I thought would be better as I can tell it where to put the data. I can set it up and it will copy my "test" name. However it won't copy over subsequent names that I add later on.

Can anyone suggest a method that would work? Or will I have to use the good ol' Copy & Paste method every time?

Thanks,
Catherine

kahawai chaser
12-03-2012, 04:24 PM
Sort of sounds like a mix of consolidated tables and vlookup function might suit. You could try a merge table wizard, but I think you need create a 2nd table specifically for orders/names. Explained here. (http://www.ablebits.com/office-addins-blog/2012/02/21/excel-update-data-merge-table/) I think there is a member on this forum that does macro's.

fred_fish
12-03-2012, 04:46 PM
If the names are in Column A on Sheet1 from row 2 down, then in Column C (or whatever) on Sheet2 put in cell C2: =Sheet1!A2 then copy it down as far as necessary. (or just push = then point and click)
So whatever you put in the target cell on Sheet1 appears on Sheet2.
Or am I missing something?

dugimodo
12-03-2012, 07:20 PM
What Fred said.

caffy
12-03-2012, 08:19 PM
Great thanks, kahawai & fred, will check those out tomorrow at work

caffy
13-03-2012, 01:25 PM
If the names are in Column A on Sheet1 from row 2 down, then in Column C (or whatever) on Sheet2 put in cell C2: =Sheet1!A2 then copy it down as far as necessary. (or just push = then point and click)
So whatever you put in the target cell on Sheet1 appears on Sheet2.
Or am I missing something?

That worked perfectly - THANK YOU! This will save me a lot of time!