If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Question About Importing Columns From A Datasheet to A Worksheet
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! |
#2
|
|||
|
|||
Question About Importing Columns From A Datasheet to A Worksheet
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! |
#3
|
|||
|
|||
Question About Importing Columns From A Datasheet to A Workshe
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! |
#4
|
|||
|
|||
Question About Importing Columns From A Datasheet to A Worksheet
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! |
#5
|
|||
|
|||
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! . |
Thread Tools | |
Display Modes | |
|
|