| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to make one column copy from one sheet to anoth column w/o zer
I am trying to copy one column from one sheet to another sheet without
getting all the zeros at the end, This is for a template that will have varying range sizes. Any suggestions??? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to make one column copy from one sheet to anoth column w/o zer
It is difficult to understand your question. I think you want to have a
formula in the new sheet that refers to the data on another sheet. Instead of just "=sheet1!A1", which will give you 0s where the cells on sheet1 are blank, you can use something like this, which writes "" (nothing) if the cell A1 on sheet1 is blank: =IF(sheet1!A1=0,"",sheet1!A1) -- Reply to post if not correct Allllen "areezm" wrote: I am trying to copy one column from one sheet to another sheet without getting all the zeros at the end, This is for a template that will have varying range sizes. Any suggestions??? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to make one column copy from one sheet to anoth column w/o zer
If sheet1!a1 actually equals 0, then your formula would hide that.
I'd use: =if(sheet1!a1="","",sheet1!a1) Allllen wrote: It is difficult to understand your question. I think you want to have a formula in the new sheet that refers to the data on another sheet. Instead of just "=sheet1!A1", which will give you 0s where the cells on sheet1 are blank, you can use something like this, which writes "" (nothing) if the cell A1 on sheet1 is blank: =IF(sheet1!A1=0,"",sheet1!A1) -- Reply to post if not correct Allllen "areezm" wrote: I am trying to copy one column from one sheet to another sheet without getting all the zeros at the end, This is for a template that will have varying range sizes. Any suggestions??? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to make one column copy from one sheet to anoth column w/o
Yes, I agree, use Dave's: it is better.
-- Reply by thread only thanks Allllen "Dave Peterson" wrote: If sheet1!a1 actually equals 0, then your formula would hide that. I'd use: =if(sheet1!a1="","",sheet1!a1) Allllen wrote: It is difficult to understand your question. I think you want to have a formula in the new sheet that refers to the data on another sheet. Instead of just "=sheet1!A1", which will give you 0s where the cells on sheet1 are blank, you can use something like this, which writes "" (nothing) if the cell A1 on sheet1 is blank: =IF(sheet1!A1=0,"",sheet1!A1) -- Reply to post if not correct Allllen "areezm" wrote: I am trying to copy one column from one sheet to another sheet without getting all the zeros at the end, This is for a template that will have varying range sizes. Any suggestions??? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup function and compare | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Formula to copy rng of cells where (value is met) to anther sheet | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| MACRO - copy rows based on value in column to another sheet | Excel Discussion (Misc queries) | |||
Linear Mode
