Copy Specific Cells To Another Worksheet

I would like the code that allows me to copy enything I typing in column a sheet1 to column a in sheet2
Thank you

If it's a limited number of rows (a couple of thousand or so) then in cell A1 on Sheet2 you could put the formula:

=IF(Sheet1!A1="","",Sheet1!A1)

And copy down as far as required.

Alternatively you could have a macro solution; would you want a macro which copies new text as soon as you've typed it, or a macro you run to copy the contents across when you wish to?

Thank you Andrew

I'm looking for a solution to allow to copies text from first sheet to the second one as soon as I type it on the first page ,unfortunately I'm just basic on excel.
I try to explain what I'm looking for:
I have to do two different tabel on 2 excel worksheets first sheet is with 50 rows on one page and the second sheet is with 10 rows on five pages is take me to long time to copy and past everything every day

If you can give me an idea it will be great

Thank you

Are you really using Excel 2008 (i.e. you're on a Mac rather than a PC)?

Hi

At home I've got an Mac and I have Excel 2008 installed ,at work I use a PC and I'm not sure what version of Excel I have there but usually I set up the pages at home and I take it with me at work on a memory stick.

OK, I don't know anything about Macs, but this should work on the PC:

Please Login or Register  to view this content.

To insert it:

1. With your workbook open (and it will be easiest if you only have the one workbook open) press Alt-F11 to open the VBA editor.
2. In the left-hand pane will be list of the sheets in your workbook, double-click on the sheet you want your typing to be copied from
3. A blank text editor window will open, in the drop-down list at the top, left-hand side of that window select "Worksheet" - A couple of lines of code will appear, don't worry about them.
4. In the drop-down list on the right-hand side select "Change" - the first and last lines of the code above will appear, paste the rest of my code in between them.
5. Close the VBA editor (red cross at the top right corner)
6. You'll no longer be able to save your workbook as an xlsx file, so save it as an xlsm (macro-enabled workbook)

Try typing something on the sheet you selected in step 2 and see how it goes.