A
A
AAR72020-08-22 12:06:54
Automation
AAR7, 2020-08-22 12:06:54

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

1 answer(s)
I
idShura, 2020-08-22
@idShura

Can be done with Power Query or vba

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question