[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
On 16/04/15 18:10, Peter Walker wrote:
You should be now seeing that spreadsheets should not be used for anything more complicated than shopping lists. Anything in the enterprise that is important should use a more 'software manageable' solution like machine code or an abacus.If I understand you correctly you are filling days in on one sheet over a period and then at some time copy that date to the other sheet. Are you then going to clear down the first sheet or will it just accumulate stuff over time? If you never clear it then the formulas will work and I think you could use vlookup to split data to different sheets for each dealership. However if you clear your scratch sheet all the other data will go as well. I away from my computer at the moment so can't remember the exert details for vlookup. Cheers Pete.On 16 Apr 2015 17:30, Daniel Robinson <manipula@xxxxxxxxx> 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
Tom te tom te tom -- The Mailing List for the Devon & Cornwall LUG http://mailman.dclug.org.uk/listinfo/list FAQ: http://www.dcglug.org.uk/listfaq