D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] Excel Spreadsheet formula

 

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.

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



-- 
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/listfaq