Lux Aeterna
Board Regular
- Joined
- Aug 27, 2015
- Messages
- 205
- Office Version
- 2019
- Platform
- Windows
@mumps
I created a new post because the other one I had was a bit confusing.
This is the Demographics sheet. We enter all data manually.
This is the Results sheet. Data in the white area is retrieved automatically from the Demographics sheet using an IF function.
For the example, the function that retrieves the name is:
Sometimes there might be a mistake in the retrieved data. That's why manual input (column AA) gets prioritised in the function, for the supervisors to be able to correct it manually.
What I'd like to be able to do, is to copy the not empty cells from column AA to the respective cells in Demographics sheet.
AA3 (name) goes to Demographics column C
AA4 (code) goes to Demographics column E
AA5 (age) goes to Demographics column I
AA7 (date 1) goes to Demographics column F
AA8 (place) goes to goes to Demographics column G
AA2 and AA6 are not needed.
Maybe you could add this macro to the other one you wrote earlier today.
By the way, I think I am going to need a small addition to that, if possible. A pop up warning in case column B is already filled. "ID (U2 content) is already printed. Continue?" And a Yes - No choice. If that's tough, don't bother.
Thank you in advance!
I created a new post because the other one I had was a bit confusing.
This is the Demographics sheet. We enter all data manually.
This is the Results sheet. Data in the white area is retrieved automatically from the Demographics sheet using an IF function.
For the example, the function that retrieves the name is:
Excel Formula:
=IF(AA3="";Demographics!W5;AA3)
What I'd like to be able to do, is to copy the not empty cells from column AA to the respective cells in Demographics sheet.
AA3 (name) goes to Demographics column C
AA4 (code) goes to Demographics column E
AA5 (age) goes to Demographics column I
AA7 (date 1) goes to Demographics column F
AA8 (place) goes to goes to Demographics column G
AA2 and AA6 are not needed.
Maybe you could add this macro to the other one you wrote earlier today.
By the way, I think I am going to need a small addition to that, if possible. A pop up warning in case column B is already filled. "ID (U2 content) is already printed. Continue?" And a Yes - No choice. If that's tough, don't bother.
Thank you in advance!