Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a macro to import field names into a spreadsheet and place them in different fields
Hello,
I have a spreadsheet format that I download exported data from our Oracle and it is in the form of an excel spreadsheet. I need to move this data into an existing excel spreadsheet that I'm using for a flat database but the fields have different names. EXAMPLE: ERFNAME -- ERMI -- ERLNAME -- ERADDR1 COFNAME -- COMI -- COLNAME -- COADRS I need to import the names from row one into row two. Right not I'm cutting and pasting the info. Is there a way to have a macro or vb (not real familiar with vb) to go to that spreadsheet that has row 1 examples and retrieve them, adding them to the database for importing? Additionally is there an additional way to select only the data that hasn't been imported previously? Thank you for any solutions. BOB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fields names do not show in excel 2007 pivot table fields list | New Users to Excel | |||
copy field settings of a field to other fields in same pivot tbl | Excel Worksheet Functions | |||
Some fields show with their field names, others with F11, F12 etc | New Users to Excel | |||
applying a macro for a specific field to a range of fields | Excel Programming | |||
help!!! how to place value in seperate field when this field is true | Excel Programming |