I have 2 Files that I would like to combine into one workbook- each having its own TAB AT BOTTOM. I would like to open a excel spreadsheet named "Comparison" and have a button "Macro" that when activated it would ask for first the file to import and then you would select the Text File (Pason Data Run 1) and it would import it into its own tab with the excel sheet.
One of the problems I have when importing the text file is (2 of the columns) need to be married together as one. ( Date & Time ) on the new worksheet and the other data in there own respective columns -- I would like the date and time to read like ( ex: "8/12/14 06:01" )
A. The problem I have had with this is when I import the text file into excel manually it does not read the date properly so I have to manually change it so it recognizes it as a date then combine the date and time into one column.
I have included an excel sheet named "How the Pason Data Should Look Once Imported as text" this is how it looks after I imported it manually - notice that column (a,b,c) are highlighted Column 'A' would not format as date so I had to create column 'B' and manually enter in the dates then in Column 'D' I combine column (C & B) to make my date and time format.
then you could run another macro for the Excel sheet (well Guide Run 1) to import into its own tab with in the new workbook.
I use both Files (Pason Data run 1 & Well guide Run 1) to run a correlation log and I need the date and times the same for that to happen.
There is a lot more I want to do but i thought I would start with this. Any help would be great.
I have attached 3 files
1- Text file that need to be import to new sheet (pason data run 1)
1- excel file that needs to be included on that same workbook juts different tab
1- example of my import into excel manually of the Pason data
Bookmarks