Copying text from sheet 1 to sheet 2 in same workbook

Closed
csdglobal Posts 3 Registration date Monday January 27, 2014 Status Member Last seen January 27, 2014 - Jan 27, 2014 at 07:33 AM
csdglobal Posts 3 Registration date Monday January 27, 2014 Status Member Last seen January 27, 2014 - Jan 27, 2014 at 08:38 AM
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

csdglobal Posts 3 Registration date Monday January 27, 2014 Status Member Last seen January 27, 2014
Jan 27, 2014 at 08:38 AM
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
0