Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Importing data into an existing workbook
Hello,
I have data on the company's server that can be exported in comma deliminated format and when I import and open, the header row is complete. My question is how do I, when importing, get the various headers to import into an existing header I have, with different names. How do I get the imported data into the headers I want each time that I import these files. Thanks Bob Reynolds |
#2
|
|||
|
|||
I think there are two ways:
1) You can import the data in a new workbook, rearrange the columns as in the destination workbook and then copy the data in your destination workbook; 2) you can write a macro to import the data directly in your workbook in the right position... Hoping to be helpful Franz Verga "Bob Reynolds" ha scritto nel messaggio . .. Hello, I have data on the company's server that can be exported in comma deliminated format and when I import and open, the header row is complete. My question is how do I, when importing, get the various headers to import into an existing header I have, with different names. How do I get the imported data into the headers I want each time that I import these files. Thanks Bob Reynolds |
#3
|
|||
|
|||
Thank you, I'm trying to do this without intervention so that everyone (20
employees in the bureau) can simply download the information and have it automatically be placed where it needs to. My problem is I don't know that much about VB or Macro's to do this. So if someone can help with vb programming or a macro to look at the imported information, with 20 rows of data and import into my existing worksheet that already has information in it. Something like: A1 = LName A2 = FName A3 = ERName A4 = ERaddr1 A5 = ERaddr2 A6 = City etc. all of these would be column headers with 20 rows of info below.... INTO A1 = CLastName A2 = CFirstName A3 = EmployersName A4 = EmployerAddress A5 = EmployerExtension A6 = City..... etc.... I need to import this and not disturb existing data, but add onto the list.... Thanks BOB imported into "Franz" wrote in message ... I think there are two ways: 1) You can import the data in a new workbook, rearrange the columns as in the destination workbook and then copy the data in your destination workbook; 2) you can write a macro to import the data directly in your workbook in the right position... Hoping to be helpful Franz Verga "Bob Reynolds" ha scritto nel messaggio . .. Hello, I have data on the company's server that can be exported in comma deliminated format and when I import and open, the header row is complete. My question is how do I, when importing, get the various headers to import into an existing header I have, with different names. How do I get the imported data into the headers I want each time that I import these files. Thanks Bob Reynolds |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking workbook data | Excel Worksheet Functions | |||
Using Excel workbook as data source for word mailmerge | Excel Discussion (Misc queries) | |||
moving data in excel without deleting existing data | Excel Discussion (Misc queries) | |||
Importing Data | Excel Discussion (Misc queries) | |||
What's the simplest way to copy data from another workbook | Excel Worksheet Functions |