[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
On 16/04/15 17:07, Daniel Robinson wrote:
Martin, Removing the $ works a treat, thank you. Now this moves onto my next issue.The callingsheet workbook has multiple worksheets, now I need to modify my formula to take cell data from every worksheet and dump it as a list into the other workbook.Is this possible?
Is your data a specific set of cells (like say x10 rows) or is it variable?If it's a specific range, you could easily create a formula for rows 1-10 to look at one sheet and then modify it for rows 11-20 to look at another sheet - your original formula mentioned the worksheet name.
If it's a variable range, that gets a bit trickier. I don't know how to do that either.
When my Excel (actually OpenOffice Calc) stuff gets this complicated, I fire up my MySQL server and break out my MySQL Editor :)
Martin -- The Mailing List for the Devon & Cornwall LUG http://mailman.dclug.org.uk/listinfo/list FAQ: http://www.dcglug.org.uk/listfaq