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!

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!

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!

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" wrote in message
...
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!

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" wrote in message
...
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!

.