Prev: can you embed a worksheet within the cell of another worksheet?
Next: Countif Formulas
From: M.J.Goode on 24 May 2010 21:20
Thank you Naftoli,

Will the data change and update on all sheets when I edit the datasheet? I'm
not sure it will.

"Naftoli" wrote:

> Copy worksheet (right click on bottom tab) and delete or re-arrange columns.
> --
> Naftoli
>
>
> "M.J.Goode" wrote:
>
> > I am asking for any help you can give me regarding the best way to import
> > columns from a datasheet into another worksheet. I have many worksheets to
> > construct but I will need to include only a few select columns from the
> > datasheet on each worksheet. Each worksheet will include a different
> > assortment of columns. It is my goal to only continuously update the
> > datasheet information, so all the changes will carry over to all the
> > worksheets without me having to manually update every sheet. I know how to
> > do this function per cell, but I cant figure out how to do it by column.
> > Please help!
From: M.J.Goode on 28 May 2010 15:19
Thank You Steve Dunn. You are fabulous! Works perfectly. :-)

"Steve Dunn" wrote:

> Do it by cell for the first cell in each column, e.g.
>
> =IF(ISBLANK(Data!$A1),"",Data!$A1)
>
> then copy those cells down as far as required.
>
>
>
>
> "M.J.Goode" <MJGoode(a)discussions.microsoft.com> wrote in message
> news:BD65F777-034A-42FB-8A84-752779BB03FB(a)microsoft.com...
> >I am asking for any help you can give me regarding the best way to import
> > columns from a datasheet into another worksheet. I have many worksheets
> > to
> > construct but I will need to include only a few select columns from the
> > datasheet on each worksheet. Each worksheet will include a different
> > assortment of columns. It is my goal to only continuously update the
> > datasheet information, so all the changes will carry over to all the
> > worksheets without me having to manually update every sheet. I know how
> > to
> > do this function per cell, but I cant figure out how to do it by column.
> > Please help!
>
> .
>
 | 
Pages: 1
Prev: can you embed a worksheet within the cell of another worksheet?
Next: Countif Formulas