Prev: if true, if not nested if funcion
Next: Embedded lookup
From: M.J.Goode on 24 May 2010 14:00
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: Naftoli on 24 May 2010 20:19
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: Steve Dunn on 25 May 2010 05:35
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: if true, if not nested if funcion
Next: Embedded lookup