Copying from Cell to Other Cells

[kyrospeare]

Hi,

I have a excel file with 7 worsheets. When I type text into a cell on the first worksheet, how can I copy that exact test into another cell either on the same worksheet or a different worksheet within the same file?

[VBA Noob]

Hi,

Surely if you need to copy it to another cell you just type your text and press return ??.

Then reselect the cell and right click and copy. Select the destination cell and right click and paste.

If you want to put text in A1 in all sheets in a workbook then right click one of the tabs and slect group then type text in A1 then right click sheet tab and ungroup sheets.

VBA Noob