Need to copy text from full "A" column to "A" column on new sheet....

**Stonesifer** · 02-14-2011, 04:51 PM

Hi all,

So my issue is one that I have seen many variables of, however, I cannot seem to find one that is specific to my needs. I am using Excel 2010 and am setting up a sales spreadsheet. I Have 4 sheets that I am using for this. I need columns A - F on sheet three (3) to copy the text from columns a - f on sheet one (1). Same with sheets 4 & 2. For instance, column A in sheet 1 is "Business Name". This column will grow indefinitely as we get more clients. I need column A in sheet 3 to copy any text added to any cells in sheet 1s A column. In which case, I could essentially type in the Business name in Sheet-1 cell-A2 and it will respectively show up in sheet3 cell-A2. automatically. and so on through A40, A150, etc. etc.

Any and all assistance is greatly appreciated!

**royUK** · 02-15-2011, 03:58 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

**Stonesifer** · 02-15-2011, 02:50 PM

Thanks! So I have attached 2 xlsx docs. 1 before and 1 after

The before is blank since any and all info i will input needs to be "autocopied" from sheet1(sales2nd-15th) to sheet2(15thRenewals). The most important part is that I need to create a formula that will copy Any text input into any row within the designated columns to the respective cells on the other page. I have input text in cells 1 - 39, however, this list will grow indefinitely so i need the formula to do this for any and all text I input at any time in cells 1 - infinity..

Hopefully this helps, thanks again.