In LOVE with KNOWLEDGE
New member
The workbook contains 2 sheets
Sheet 1 in green tab is the sheet the user will fill out. (I have so many validations set on the page because the user is always never filling out the proper info)
I want it be setup to where once the user goes to the drop down in the column technically closed and select “yes Technically Closed” it goes away from sheet 1 and goes to sheet 2.
But all fields need to be filled out in that row before the information goes to sheet 2 The information they entered automatically goes to 2 and off of sheet 1
In the same format on the same row but on sheet 2
In to the column that corresponds to it
Because the sheets are not set up the same
Sheet 2 has more columns as sheet 1
However, every column in sheet 1 is in sheet 2
email me for the file [email protected]
Sheet 1 in green tab is the sheet the user will fill out. (I have so many validations set on the page because the user is always never filling out the proper info)
I want it be setup to where once the user goes to the drop down in the column technically closed and select “yes Technically Closed” it goes away from sheet 1 and goes to sheet 2.
But all fields need to be filled out in that row before the information goes to sheet 2 The information they entered automatically goes to 2 and off of sheet 1
In the same format on the same row but on sheet 2
In to the column that corresponds to it
Because the sheets are not set up the same
Sheet 2 has more columns as sheet 1
However, every column in sheet 1 is in sheet 2
email me for the file [email protected]