Question About Importing Columns From A Datasheet to A Worksheet

  • Thread starter Thread starter M.J.Goode
  • Start date Start date
M

M.J.Goode

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.
 
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.
 
Back
Top