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
|
|||
|
|||
get data from another sheet by specific column header
I would like to be able to get data from a different workbook and have it
inserted into a current worksheet. get all data under column header DATE in ocnewdata.xls and put in column A get all data in column VERIFIER in ocnewdata.xls and put in column B etc. I'm trying to do this because the originating spread sheet can have varying columns in number and name and position but I only want the certain columns of data. I tried getdata but I only get the whole worksheet. any suggestions would be appreciated TIA -- Stephen King ACC Brisbane Australia |
#2
|
|||
|
|||
Stephen King wrote:
I would like to be able to get data from a different workbook and have it inserted into a current worksheet. get all data under column header DATE in ocnewdata.xls and put in column A get all data in column VERIFIER in ocnewdata.xls and put in column B etc. There are a number of options available: 1) Data / Import External Data / New Database Query 2) Data / Consolidate 3) Data / Filter/ Advanced Filter / Copy to another location Depends on whether you are able to have the source workbook open at the time, and whether you are happy to use a macro to do the update. If the answer to both is yes, I would use (3) and a macro in the destination workbook along the lines of Sub GetMyData() With ThisWorkbook.Sheets("Destination") 'clear old content but leave headings .Activate .Range("A1").CurrentRegion.Offset(1).ClearContents Workbooks("SourceBook.xls").Sheets("SourceSheet"). _ ActiveWorkbook.Range("A1").CurrentRegion.AdvancedF ilter _ action:=xlFilterCopy, _ CopyToRange:=.Range("A1").CurrentRegion End With End Sub Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Splitting multiple data from 1 column to multiple columns | henry | Worksheet Functions | 0 | April 27th, 2004 05:05 PM |
adding values from another worksheet by matching criteria | Frank Kabel | Worksheet Functions | 2 | March 16th, 2004 03:15 PM |
Chart Source Data Ranges Changing when Data Sheet updated from text file source. | Tekn0 | Charts and Charting | 3 | January 8th, 2004 04:45 PM |
query - search and find data in one sheet from another. | SS | Worksheet Functions | 0 | December 3rd, 2003 08:24 PM |
Retaining Data Point Colors while Deleting a previously plotted Column? | Ken Black | Charts and Charting | 4 | October 17th, 2003 03:54 PM |