Hello everyone
I have the following file that works well but I'm having trouble getting it to the exact point.
More illustration about file
The data starts and formulas at row 8
- It will be transferred data from the Main sheet Depending on next month in column C to two sheets Results & Archive At one time.
- It will be deleted data transferred from the main sheet automatically and at the same time the data will be kept in the archive sheet for reference when needed
- It will be cleared data in the Results sheet automatically with the system date changed so that it is ready for new contents to be added.
But there is a problem in the case of the date condition is met in the column C with the 8 row (The beginning of the data transfer) that contains the range of formulas... How can I add a condition to copies the Range of formulas to next row only Before the deletion process from main sheet if the date condition is met in the column C ... Hope I've been clear enough... .Please have a look at the file.Thank you in advance for any effort
Bookmarks