Macro to combine a Text File & Excel file into one Separate workbook

That worked awesome I then created another button for my other file and just modified it for Comma Delimited for it to import into another tab and all is good up to this point.

My next task is to Take the 2 newly created worksheets and combine them into a correlation log.

I am looking for my New Date & time from the Pason Data to Correlate with the Corr. Date column on the other sheet.

I attached the way it is now and added the Log worksheet that shows how this was done manually Notice that the Columns highlighted red are form the Pason data that is brought over and correlated up with the time on the Well guide sheet.

How would I add new Button that would combine these 2 sheets

I have quite a few things I am trying to do and I figured breaking it up would be easier

Thanks again your great

Here goes I am trying to explain best I can I hope this helps.

It is hard to explain -- I have attached 2 files (1) "Snapshot of finished correlated Log" & (2) "Combine Corr Log with Initial Import Macros"

On the first "Snapshot of finished correlated Log" it shows you how the correlation is set up under Tab 'Correlated Log' and that information is highlighted Red
It pulled that data from the Tab "WG205RUN1PASONDATA" and under that tab the information I highlighted Blue is where the VLOOKUP gets its info from

Now On the other sheet "Combine Corr Log with Initial Import Macros" - I have included the Import macros under sheet 1 - Then the next 2 Tabs are the actual TXT files that got imported. I have
removed a lot of the data going down the sheet because it is quite large, but now the next tab is "Unfinished Correlated Log" & I want that to replicate the correlated Tab form the Snapshot file I
provided on the other sheet.

What they have been doing is making a copy of the 2nd Tab "WG205RUN1gda_log" and then merging all the data from "WG205RUN1PASONDATA" Tab using VLOOKUP - Once they begin they start by

Adjusting the "Corr. Date Column" by subtracting (0.291666666666667) from the (Date column) all the way down the sheet.

Then they have been just inserting new columns and using VLOOKUP merging the 2 sets of data. and do that for all the columns that were highlighted in red on the Snapshot file.

I have already Inserted Columns to help you know where it goes but the Snapshot file shows you also with it all together.

Maybe this help clarify :

I would like to insert a column at "g" and Inset this VLOOKUP "=VLOOKUP('Unfinished Correlated Log'!F3,WG205RUN1PASONDATA!$C$2:$N$5281,2) into that cell

PS is there a way to change the formula to read all the way down the sheet to capture any data in that range -- Right now my range is c2:n5281 but that changes depending on how big the log is?

I want the column to have the header Title "Hole Depth" And I would like this to continue down the whole Column. Also the Column has to be formatted as number with 2 dec places.

This is the first Column Once I get a macro to complete this one I would just need to add the other columns in the same format just change my VLOOKUP formula