tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,210
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi everyone,
I have a tab that's set up to make it easy to input data
which is then moved to the "Events" tab as a list
I want to be able to pull the data back from the "Events" tab into the "Form" tab so more data can be added it can be edited etc.
So what I'd like is a way to run a macro that looks at the client name in Sheet "Form" cell D6
then goes to the "Events" tab and find the row that client is on
Then moves the following
Events Column D to Form Cell G6
I have a tab that's set up to make it easy to input data
which is then moved to the "Events" tab as a list
I want to be able to pull the data back from the "Events" tab into the "Form" tab so more data can be added it can be edited etc.
So what I'd like is a way to run a macro that looks at the client name in Sheet "Form" cell D6
then goes to the "Events" tab and find the row that client is on
Then moves the following
Events Column D to Form Cell G6
Events Column R to Form Cell D8
Events Column H to Form Cell P4
Events Column L to Form Cell P5
Events Column S to Form Cell L6
any ideas how i can do this
Thanks
Tony
Events Column H to Form Cell P4
Events Column L to Form Cell P5
Events Column S to Form Cell L6
any ideas how i can do this
Thanks
Tony