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???
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???
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???
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
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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks