Hi
I have 7 sheets including the table as you can see on the attached. Now, each sheet is allocated to individual items e.g. item 10, item 20 and so on. I can't figure out how to return all the Item 10, 20, 30 ... to the corresponding sheet. It says Item 40 to all sheets.
Please can you assist me on this.
Thanks a lot.
Please check the file
Cheers
You've been very helpful, it works. Thanks a lot.
Test Ex.xlsm
Try that
Elegant Simplicity............. Not Always
Sorry I thought my issues had been resolved but when I did it on the actual spreadsheet the rest of the items aren't showing on the sheets. I have attached the file again, thanks for all the assistance.
Last edited by pamela16; 02-11-2014 at 04:37 PM.
I have tried changing the range but I can't figure out how to do it or make formula right.
Please help
Hi Azumi, I know you've sent. Reply earlier and it was a big help but when I actually do it on the actual spreadsheet that I was doing the items are on the column are not returning the information. I have re-attached the document. Just wondering if you could lend a helping hand once again. ThanksOriginally Posted by azumi
Okay see the links.....
Seem you missed the last part of formula in
ROW('OOD (conv)'!A10) --> should be ROW('OOD (conv)'!A1) in the first row
Cheers
Hi Azumi, again thank you so much for that. Just out of curiosity where you get the *1048577 n the formula? So I know next time I try to do it myself.
I am also stuck on the same issue. For me, the formula is only listing one row. Rather only one column.
Great spreadsheet
Can this work with a master table that has 10000 rows with 12 entries each?
Hi, welcome to the forum
Unfortunately your post does not comply with Rule 4 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks