kt_mr_excel
New Member
- Joined
- Sep 24, 2021
- Messages
- 15
- Office Version
- 365
- 2016
- Platform
- Windows
Help! I have a very large volume of spreadsheets that were converted from PDF files and need to correct some column shifts that resulted from the conversion. The worksheets have thousands of rows that would need all cells to be shifted to the right from a variable starting column and variable amount by row. I have two columns, A & B, where A displays the letter value of the starting column to shift (like "L") and B contains a numeric value indicating the amount to shift. So ideally, I need to start on row 2 (to avoid the header row) and loop through all rows that contain data (rather than a fixed number of rows) and perform the appropriate shift for each row based on the values in columns A & B. I've found some similar logic in the forum but nothing that handles all of the variables. Any help will be be GREATLY appreciated!