That's not really my question(s). I can write a function that checks sheet3, then sheet2, then sheet1.
But that's not very efficient if tomorrow you have to check 4 sheets, then 5 on the next day. also, a function could work for 20-30 rows, but if you get into a larger spreadsheet, the recalculation time could be excessive. so: 1) Will there ALWAYS be a total of (4) sheets 2) would you rather have a function used on each row, or a VBA macro (and button) that refreshes the entire list? Paul ----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----------------------------------------- ________________________________ From: Pravin Gunjal <isk1...@gmail.com> To: excel-macros@googlegroups.com Sent: Thu, December 6, 2012 8:32:10 AM Subject: Fwd: $$Excel-Macros$$ Reference cells value required with condition Hello Sir Thanks for your reply. I required the last updated value which may come from any of the sheets. If it is not available in sheet3, then it should get from sheet2; if it's not available in sheet2 also then it should get from sheet1 otherwise ZERO. Regards Pravin. ---------- Forwarded message ---------- From: Paul Schreiner <schreiner_p...@att.net> Date: Thu, Dec 6, 2012 at 6:53 PM Subject: Re: $$Excel-Macros$$ Reference cells value required with condition To: excel-macros@googlegroups.com r would you rather copy a function down and have it refr -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
