copying a column from one worksheet to another

mzsaad

New Member
Joined
Aug 24, 2006
Messages
27
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?
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
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...
 

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
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

New Member
Joined
Aug 24, 2006
Messages
27
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

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
... 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 :confused:
 

Forum statistics

Threads
1,141,757
Messages
5,708,346
Members
421,566
Latest member
7Nabisco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top