Answer the question
In order to leave comments, you need to log in
Automation of data transfer from Sheet 1 to Sheet 2 based on the parameters. How to implement in Excel?
Conditions:
There are 2 sheets in Excel: "Sheet1", "Sheet2" in one document.
Sheet1 has 3 rows (1,2,3) and 3 columns (A,B,C).
In "Sheet2" there is a column A.
In "Sheet1" In column A there is a text (let's call it t), in column B - the current date, in column C - a date set manually.
In "Sheet2" column A is just an empty cell.
Task:
If in "Sheet1" the date difference between B1 and C1 >= 3 days, then:
Cut the text(t) from A1 and paste it into "Sheet2" A1.
Ideally, the following action would also be: delete the row in which there was text on "Sheet1" in order to pull the bottom value higher and there were no empty lines.
This is the kind of task that needs to be automated.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question