Finalfight40
Active Member
- Joined
- Apr 24, 2018
- Messages
- 273
- Office Version
- 365
- Platform
- Windows
Hi All
I am just having some trouble with a few lines in a macro i am trying to create.
Currently i am in an active cell on one of my tabs which is a date. I would like to use this date to find a matching date in another sheet in the currently active row.
For example if i am in row 43 on my second sheet, it will only look at row 43 for the date that matches my currently active cell on the first sheet and go to it. How could i do this because i have multiple dates on the same sheet but the dates in the row i am looking up would be unique?
Thanks in Advance
I am just having some trouble with a few lines in a macro i am trying to create.
Currently i am in an active cell on one of my tabs which is a date. I would like to use this date to find a matching date in another sheet in the currently active row.
For example if i am in row 43 on my second sheet, it will only look at row 43 for the date that matches my currently active cell on the first sheet and go to it. How could i do this because i have multiple dates on the same sheet but the dates in the row i am looking up would be unique?
Thanks in Advance
Last edited: