Question About Importing Columns From A Datasheet to A Workshe
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!
.
|