Access (pwehh!) would do the the trick. Open/Libre Office Base would
work also - and probably more reliably...
:)
On 16/04/15 17:56, Daniel Robinson
wrote:
Unfortunately SQL isn't available, my desktop is a
VDI session which would need to be accessed by myself and a line
manager from a shared drive.
I also don't understand SQL so would Ms Access also be an
alternative?
Yeah, so a variable
list then. I don't think you'll be able to do it easily in
Excel
It seems to me that this data would be more useful in a
proper database - you'd be able manipulate the reports you
needed much more easily...
Martin
On 16/04/15 17:30, Daniel Robinson wrote:
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..
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 :)
