nooks12
New Member
- Joined
- Feb 1, 2023
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
Hi. Recently, our IT changed our drive paths at work. I have many excel files that reference data in other files. I have a bunch of files each with several sheets where each sheet has several columns that have references for all columns. See below for sample column reference. You'll see that each new row has a filename that includes a date, incremented by one. I need to update each row by one day from early Feb to end of Jan following year. Is there a simple block of code that will do that for me. I do not have a coding background, but want to avoid days of updating each of these rows in all of these files. Thank you.
column A
row 1 file path string + filename_2023-02-06
row 2 file path string + filename_2023-02-07
row 3 file path string + filename_2023-02-08
Cheryl
column A
row 1 file path string + filename_2023-02-06
row 2 file path string + filename_2023-02-07
row 3 file path string + filename_2023-02-08
Cheryl