Macro convert text to number & copy criteria from another sheet

Greetings All,

I am new to vba and have searched this forum to find my answer but have no idea what I'm doing.
Would anyone know how add a vba to this existing macro so I wont have to do a vlookup after running the macro.
1. Remove dashes and spaces from spreadsheet 1(detail) in column A:A
2. Convert stored text to numbers
3. Searches criteria in ASM File for value from Detail sheet column A
4. Pastes Entire Row into Macro Data Sheet
5. Then the results found in "macro data" sheet, copy rows from column BG & BH and paste in to the Detail Sheet column B & C.

This macro searches a value in "Detail" sheet in the "ASM file" and copies the entire row then pastes in a different sheet named "Macro Data." I use this macro on a large data CSV file with over 100,000 line items and then do a vlookup in the macro data file to pull matching cell data from column BH & BG. I use this vlookup formula =VLOOKUP($A2,'Macro Data'!$A:$BH,59,FALSE) and =VLOOKUP($A2,'Macro Data'!$A:$BH,60,FALSE)

Typically before running the macro I format my cells to remove dashes and convert to number then run this existing macro on a CSV file where the macro copies the entire row into the macro data tab. I also do a vlookup to find the results in the Macro Data sheet for columns BG &BH which are columns 59 and 60, I like to skip these steps. Any help to creating a macro that eliminates the vlookup step for me.

Please Login or Register  to view this content.

Hi nb - as discussed in your previous thread, please edit your post to include code tags.
Just select the relevant macro text and click the # icon on the editing toolbar.