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 Apr 2015 5:21 pm, "Martin Gautier"
<
martin.gautier@xxxxxxxxxxxxx>
wrote:
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
