Copying text from sheet 1 to sheet 2 in same workbook [Closed]

Report
Posts
3
Registration date
Monday January 27, 2014
Status
Member
Last seen
January 27, 2014
-
Posts
3
Registration date
Monday January 27, 2014
Status
Member
Last seen
January 27, 2014
-
Hello,

Greetings everyone, I am a new user here.

I wondered if anyone could please help me with copying text data from sheet 1 of a workbook to sheet 3 of the same workbook (usually about 10 rows)

many thanks for your help it is most appreciated.

1 reply

Posts
3
Registration date
Monday January 27, 2014
Status
Member
Last seen
January 27, 2014

Hi

I wonder if anyone can please help me with this?

I have found a solution to my question above re copying text data from sheet 1 to sheet 3 within the same workbook. (the formatting in sheet 1 was causing the problem).

My next problem is that where there is a blank in sheet 1 I need it to show as a blank in sheet 3 (at the moment it is showing a 0 because of the formula).
Could anyone please help with this. I would be very grateful

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!