Pat_The_Bat
Board Regular
- Joined
- Jul 12, 2018
- Messages
- 82
I am new to the forum, and while I considered myself an expert in Excel, now that I have started working with Macros and VBA, I am a humble beginner again!
What I'm trying to do is the follow...
Look at all cells in range B2:B100 and if B2 contains X, then copy the contents of C2 and add it to the next available empty cell on Sheet 2 Column C.
I'm starting some basic classes so I am getting the programming down at its basic form, but the syntax for this must be over my head a bit.
Any help would be appreciated.
What I'm trying to do is the follow...
Look at all cells in range B2:B100 and if B2 contains X, then copy the contents of C2 and add it to the next available empty cell on Sheet 2 Column C.
I'm starting some basic classes so I am getting the programming down at its basic form, but the syntax for this must be over my head a bit.
Any help would be appreciated.
