Maybe it's not that challenging....but it is to me! Please see attachment and any help is appreciated.
Maybe it's not that challenging....but it is to me! Please see attachment and any help is appreciated.
Please confirm whether it needs to be achieved using formula or VBA code?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi and welcome to the forum
do you mean physically move it (so that it is not in the other sheet any more), or just reference the values from that row?If a Cell in Column H in the Sheet 'Data' has a value > 0, move all contents of the row of that cell, including the hidden row A, in to the summary sheet.
If you mean to physically move, then no formula will do that for you, you will need VBA.
If you just want to reference the data, then on sheet 2 in I3, copied down, use this...
=IF(H3=0,I2+1,I2)
Then where-ever you want the answer, use this, copied down...
=IFERROR(INDEX(Data!$A$2:$H$10,MATCH(ROW(A1),Data!$I$2:$I$10,0),COLUMN(A1)),"")
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
I just want to reference the data, so just by formula. Thanks a lot for this direction so far, it looks like it is getting close. I plugged in the IF and IFERROR, but the result is essentially the opposite of what I need - it is referencing the data where cells in column H are 0. I need to reference these cells when they are not 0. Does the IF in column I in sheet 2 need to be reset?
thanks a lot
John
Sorry...I need to reference cells when they are >0.
OK so maybe...
=IF(H3>0,I2+1,I2)
=IF(H3>0,I2+1,I2) , i did in this way instead of H3=0 in the Data sheet and iam getting the answer . Hope this was helpful
Thank you simran and Mr. Dibbins, you have been very helpful. I've had success with the simplified sheet, but have attached a sample of the sheets I am working with. There are about 15 sheets, and these are 2 of them. Same challenge but expanded. One of the issues across the sheets is that there are spaces between rows...does this cause an inherent glitch in referencing the list?
Thanks again for your help.
John
and please see Summary Sheet for description....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks