MaxymilianFrostkowski
0 deals
on 2022-11-16
[EXCEL] Automatic movement of rows to second worksheet
Employer
Description
I have two sheets within one file, let's call them sheet 1 and sheet 2. In sheet 1 there are a lot of rows and columns. However, one of the columns is important and is supposed to define a change. There is a select thrown in there with a checkbox of 3 statuses. Let's call them open, closed, paid. I would like to have the data automatically move to sheet 2 when closed or paid status is set, leaving in sheet 1 the data with open status only.
Please give me suggestions on how this could be done. This is not to be a one-time action, as I work on the file regularly.
Published
on 2022-10-26
Category
The job in figures:
Set rules in the file that will solve the problem described above.
Skills
Offers sent (22)
ExcelOn Optymalizacja Procesów
3 deals
on 2022-11-14
dominik246890
0 deals
on 2022-11-13
SoNL
0 deals
on 2022-11-13
GrzegorzF
0 deals
on 2022-11-08
VMT
86 deals
on 2022-11-04
e-api.pl
0 deals
on 2022-11-03
Piotr Szpura
0 deals
on 2022-11-02
SergD
6 deals
on 2022-11-01
[email protected]
0 deals
on 2022-10-31