Phil Smith
Active Member
- Joined
- Aug 13, 2004
- Messages
- 285
- Office Version
- 365
- Platform
- Mobile
Hello Excel People!
In column A on one worksheet, "Base Roster", I have a column of numbers, in order from 1 to 70.
In Column A on another worksheet, "My Roster", I also have a column of numbers, but they are not in ascending order.
As my code loops through and fills in worksheet "Base Roster" with all the details from the basic and unformatted roster from work, once it has filled in a week, I would like to copy that week, for example the range being "Week1" to the corresponding row in "My Roster", but I dont know how to find the row in "My Roster" using VBA.
For this example, A1 on "Base Roster" contains 1. The formatted 70 line roster is over 560 rows with each day taking 8 rows.
On "My Roster", line 1 doesn't apppear until A225, but it is getting that magic number, 225, that I am stumped on.
So you wonderful VBA wizards, over to you fine people!
In column A on one worksheet, "Base Roster", I have a column of numbers, in order from 1 to 70.
In Column A on another worksheet, "My Roster", I also have a column of numbers, but they are not in ascending order.
As my code loops through and fills in worksheet "Base Roster" with all the details from the basic and unformatted roster from work, once it has filled in a week, I would like to copy that week, for example the range being "Week1" to the corresponding row in "My Roster", but I dont know how to find the row in "My Roster" using VBA.
For this example, A1 on "Base Roster" contains 1. The formatted 70 line roster is over 560 rows with each day taking 8 rows.
On "My Roster", line 1 doesn't apppear until A225, but it is getting that magic number, 225, that I am stumped on.
So you wonderful VBA wizards, over to you fine people!
