copying a column from one worksheet to another

[mzsaad]

hi,
what i m trying to achieve doesnt sound very difficult.
however here is what i need to achieve:

i want to copy one column from a worksheet to another worksheet.

i m doing =NameofSheet!C1 and then copying it down all the way down to 1000

even though column is just 300 rows but i m copying it down to 1000 cause i need to automate the sheet and sheet might have more entries in the future.

here is what happens, the columns that doesnt have anything show me 0. i dont need zeros in those fields. i need it to show it as blank fields.

any way to achieve this?

 

[NBVC]

You can try custom formatting the column as General;;


This hides all 0's.....if you want some 0's to appear you will have to use an If() formula...

 

[mzsaad]

thanks for the quick reply.

man i tried it. not working for me

 

[NBVC]

What's not working? The custom formatting?

Select the column, go to Format Cells, select the Number tab and select Custom from the list.

Type General;; in the Type Box.


If you want the IF() formula, then try:

=IF(NameofSheet!C1="","",NameofSheet!C1)

 

[mzsaad]

What's not working? The custom formatting?

Select the column, go to Format Cells, select the Number tab and select Custom from the list.

Type General;; in the Type Box.


If you want the IF() formula, then try:

=IF(NameofSheet!C1="","",NameofSheet!C1)

bro, i did what how u said it.
General formatting still showed me zero.

However i tried
=IF(NameofSheet!C1="","",NameofSheet!C1)
whih works like a charm.

thanks.

 

[NBVC]

... i did what how u said it.
General formatting still showed me zero.
...
thanks.

Did you type 2 semi-colons after General? Should've worked