Macro to search and copy specific info on the next blank line [Closed]
jlo333
Posts Monday July 29, 2013Registration date
July 29, 2013
Last seen
-
Jul 29, 2013 at 11:16 AM - Latest reply: TrowaD2345
Posts Sunday September 12, 2010Registration dateContributorStatus
April 23, 2018
Last seen
- Jul 29, 2013 at 12:04 PM
I am hoping someone can help me. I will be as detailed as possible, but please let me know if you need more information from me.
What my end goal is for this to happen:
Staff are to enter information on an a worksheet "Absence Memo".
I then need some of this information to then copy over to a worksheet called "ProjectedActual".
The first thing that would need to take place though would to have Absence Memo B7 (Name of Physician) to be searched and then found in the ProjectedActual sheet. The name would only appear once.
After the search is done, the following information is required to transfer and entered in the next blank line after the doctors name:
- Absence Memo E12 to ProjectedActual column D
- Absence Memo G12 to ProjectedActual column B
- Absence Memo I12 to ProjectedActual column C
It would be A6 (after the name), but sometimes information will already be in that row, so it would need to go into A7 then. So I need it to determine where the next blank row is before it copies the information.
