Macro to search and copy specific info on the next blank line
Closed
jlo33
Posts
3
Registration date
Monday July 29, 2013
Status
Member
Last seen
July 29, 2013
-
Jul 29, 2013 at 11:16 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jul 29, 2013 at 12:04 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jul 29, 2013 at 12:04 PM
Related:
- Macro to search and copy specific info on the next blank line
- Www.google.com search video - Download - Video playback
- Yahoo search history - Guide
- How to search a youtube channel - Guide
- How to search for words on a page - Guide
- Spybot search and destroy - Download - Antivirus
5 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Jul 29, 2013 at 11:31 AM
Jul 29, 2013 at 11:31 AM
Hi JLo,
To prevent searching for the entire sheet, where is the Physician Name located on the ProjectedActual sheet in terms of row or column?
Best regards,
Trowa
To prevent searching for the entire sheet, where is the Physician Name located on the ProjectedActual sheet in terms of row or column?
Best regards,
Trowa
jlo33
Posts
3
Registration date
Monday July 29, 2013
Status
Member
Last seen
July 29, 2013
Jul 29, 2013 at 11:33 AM
Jul 29, 2013 at 11:33 AM
Column A
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Jul 29, 2013 at 11:51 AM
Jul 29, 2013 at 11:51 AM
One more thing.
If name is found in A5 then the pasted info would come in row 5 (after the name) or row 6 (below the name).
If it is row 6, will A6 be empty?
If name is found in A5 then the pasted info would come in row 5 (after the name) or row 6 (below the name).
If it is row 6, will A6 be empty?
jlo33
Posts
3
Registration date
Monday July 29, 2013
Status
Member
Last seen
July 29, 2013
Jul 29, 2013 at 11:55 AM
Jul 29, 2013 at 11:55 AM
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.
Didn't find the answer you are looking for?
Ask a question
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Jul 29, 2013 at 12:04 PM
Jul 29, 2013 at 12:04 PM
Now I am confused.
Column A is filled with names, right?
Could you post a sample of data or maybe post your workbook using a filesharing site like www.speedyshare.com or ge.tt, for better understanding.
Out of time for today, get back to you tomorrow.
Best regards,
Trowa
Column A is filled with names, right?
Could you post a sample of data or maybe post your workbook using a filesharing site like www.speedyshare.com or ge.tt, for better understanding.
Out of time for today, get back to you tomorrow.
Best regards,
Trowa