I have converted pdf reports to excel but each page records the data in different columns and i would like to skip throuh the data in the first row, that could be anywhere on the sheet, Once this ow has been located i need to move the left once cell at a time examine the value and store the address to new variable that can be used by another module that writes the data to a new worlbook and worksheet.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Examine cells in row for data with vba
-1