Hello,
Is it possible to have an INDEX MATCH to return a second value that is in the same cell number?
For example: the formula returns the value from A1, Sheet2 but also the value from A1's of Sheet3/4/5...
Regards,
Red
Hello,
Is it possible to have an INDEX MATCH to return a second value that is in the same cell number?
For example: the formula returns the value from A1, Sheet2 but also the value from A1's of Sheet3/4/5...
Regards,
Red
If you want to pull in a value based on teh same criteria, but from a different sheet, just change teh sheet name
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you for your reply.
Every time I run my macro to enter data, it moves up 1 cell to the right and adds the new data in place next to the names.
If I had a different solution to my date entries then indeed, changing the sheet name is the solution.
Names are always in column A no matter which sheet (4 of them).
Run macro today:
(Sheet1) Realrookie 16/02/2016
(Sheet2) Realrookie 52013
(Sheet3) Realrookie 258
(Sheet4) Realrookie 987
Run macro tomorrow:
(Sheet1) Realrookie 17/02/2016 16/02/2016
(Sheet2) Realrookie 48593 52013
(Sheet3) Realrookie 369 258
(Sheet4) Realrookie 7852 987
This causes all data related to each other to be in the same cells on all sheets (Sheet1-4, C4 all belong to the same data to the according name)
If it was just 1 person, easy fix and less complicated. But the data is imported with +/-58 names (x5 for 5 days a week)
As I cannot figure a macro out to post the date separately on every sheet, as the date shows up 5 times per name.
I am trying (!!) to make sample sheet to explain what I mean. I know it sounds confusing but it sounds better in my head...
Regards,
Red
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks