Forum Home
Press F1
Thread ID: 123700	2012-03-12 02:56:00	Replicating Text in Excel Sheets	caffy (2665)	Press F1

Post ID	Timestamp	Content	User
1264506	2012-03-12 02:56:00	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: . microsoft . com/en-us/support/5-tips-for-working-with-multiple-worksheets-in-excel-HA001042919 . aspx" target="_blank">office . microsoft . com 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 . youtube . com/watch?v=BdG43GjIwRg" target="_blank">www . youtube . com 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	caffy (2665)
1264507	2012-03-12 04:24:00	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. (www.ablebits.com) I think there is a member on this forum that does macro's.	kahawai chaser (3545)
1264508	2012-03-12 04:46:00	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?	fred_fish (15241)
1264509	2012-03-12 07:20:00	What Fred said.	dugimodo (138)
1264510	2012-03-12 08:19:00	Great thanks, kahawai & fred, will check those out tomorrow at work	caffy (2665)
1264511	2012-03-13 01:25:00	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!	caffy (2665)
1