steve400243
Active Member
- Joined
- Sep 15, 2016
- Messages
- 429
- Office Version
- 365
- 2016
- Platform
- Windows
Hello I have several hundred files in a folder on My Desktop with a general name 'New Folder'. I am looking for a way to open each file and input the following into the noted cells in each file. Thanks for looking and any help provided. I also provided an example of one of the files with the correct formulas in the mentioned cells.
in cell H5 for each file -
in cell H6 for each file -
in cell H7 for each file -
in cell H5 for each file -
VBA Code:
=IF(H4="","-",H4+6)
in cell H6 for each file -
Code:
=IF(H4="","-",H4+11)
in cell H7 for each file -
Code:
=IF(H4="","-",H4+15)
YM UPWARD 2080.xlsx | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | Packet Received: | |||||||||
2 | ETA Date: | 01/17/22 | Container Released: | |||||||
3 | Master B/L: | YMLUW236642080 | Received Container: | |||||||
4 | Vessel | YM UPWARD | Devanned On: | |||||||
5 | Container#: | YMLU9536528 | Storage - 7th Day: | - | ||||||
6 | Intensive Exam Date: | 12th day: | - | |||||||
7 | VACIS Exam Date: | GO Date: | - | |||||||
8 | Customs Exam Date: | |||||||||
9 | ||||||||||
CFS SHEET |
Cell Formulas | ||
---|---|---|
Range | Formula | |
H5 | H5 | =IF(H4="","-",H4+6) |
H6 | H6 | =IF(H4="","-",H4+11) |
H7 | H7 | =IF(H4="","-",H4+15) |