Dmetcalf2021
New Member
- Joined
- Jan 26, 2021
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
I am trying to create code that will copy data from selected cells on (Enter Data) worksheet and place in the first blank corresponding cell of (Inv History) worksheet
Copy from (Enter Data) "G5" paste to first blank cell in column A of (Inv History)
Copy from (Enter Data) "G8" paste to first blank cell in column B of (Inv History) - This one has a formula so has to be posted as special number or it will disappear when I clear contents of entry screen
Copy from (Enter Data) "G3" paste to first blank cell in column C of (Inv History)
Copy from (Enter Data) "G1" paste to first blank cell in column D of (Inv History)
Copy from (Enter Data) "G6" paste to first blank cell in column E of (Inv History)
I'm sure this is simple for someone but I have tried to make this work for 2 days and I just don't know enough VBA. Can someone please help me? I have other macros that are working for my process but I can't seem to figure this one out!
Copy from (Enter Data) "G5" paste to first blank cell in column A of (Inv History)
Copy from (Enter Data) "G8" paste to first blank cell in column B of (Inv History) - This one has a formula so has to be posted as special number or it will disappear when I clear contents of entry screen
Copy from (Enter Data) "G3" paste to first blank cell in column C of (Inv History)
Copy from (Enter Data) "G1" paste to first blank cell in column D of (Inv History)
Copy from (Enter Data) "G6" paste to first blank cell in column E of (Inv History)
I'm sure this is simple for someone but I have tried to make this work for 2 days and I just don't know enough VBA. Can someone please help me? I have other macros that are working for my process but I can't seem to figure this one out!