[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
The workbook: Scrap calling sheet
Each worksheet : Dealerships i.e. Vospers.
Inside each worksheet is a list of each Dealership site, Truro, Exeter, Exmouth etc.
The columns are, date. acc no. acc name. Number of scrap. Name of contact.
I call weekly so each dealership has multiple sites that are contacted weekly. Which are listed down over time.
The code needs to take out what I type and list it into another workbook so that I don't have to duplicate my work.
Does that make any sense?
On 16/04/15 17:07, Daniel Robinson wrote:
Is your data a specific set of cells (like say x10 rows) or is it variable?
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?
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
-- The Mailing List for the Devon & Cornwall LUG http://mailman.dclug.org.uk/listinfo/list FAQ: http://www.dcglug.org.uk/listfaq