Macro to search and copy specific info on the next blank line
Closed
jlo33
TrowaD
- Posts
- 3
- Registration date
- Monday July 29, 2013
- Status
- Member
- Last seen
- July 29, 2013
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- Macro to search and copy specific info on the next blank line
- How to search for a specific youtube channel - Guide
- Run macro when cell changes to specific value - Guide
- Macro to search for a value in excel - Guide
- Cell colour containing specific info ✓ - Forum - Excel
- Macro for filling data from specific cell to another ✓ - Forum - Excel
5 replies
TrowaD
Jul 29, 2013 at 11:31 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
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
Jul 29, 2013 at 11:33 AM
- Posts
- 3
- Registration date
- Monday July 29, 2013
- Status
- Member
- Last seen
- July 29, 2013
Jul 29, 2013 at 11:33 AM
Column A
TrowaD
Jul 29, 2013 at 11:51 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
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
Jul 29, 2013 at 11:55 AM
- Posts
- 3
- Registration date
- Monday July 29, 2013
- Status
- Member
- Last seen
- July 29, 2013
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
Jul 29, 2013 at 12:04 PM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
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