Recent content by scribbler99

When browsing for an answer to the above I saw where others had similar problems but spanning tabs. I read what you say SkipVought but have uploaded an image so that you can see what we're after. The presentation of this spreadsheet was the reason not all data was in the same column. The cell...

Hi Guys, please can someone enlighten me in what I presume, to the professional out there, requires a simple solution. I have two columns on an excel 2007 spreadsheet that I am trying to get the average on and exclude any blanks. my formula that works for one column is...

Please can anyone help. I have an Excel workbook containing a number of worksheets. My problem is that on one sheet(Bulk Pick) I have Rows containing headings(Location Names)and a column containing Product names. I wish to lookup the corresponding value contained at the matching intersection on...

Gruuuu I did realise that and presume Skip did too. I just felt I needed to comment as a sign of gratitude for the help Skip had provided. I have been on the receiving end of Skips annoyance recently for not being clear in my descriptions/code so it's pleasing to know you are all only human...

Thanks Skip. That did the trick perfectly. Never mind Gruuuu's comment at least you asnwered my prayers.

If I am understanding this correctly I have placed Skips code into Module1 Then also Private Sub Workbook_Open Call SumSummary End Sub Private Sub Workbook_SheetChange event Call SumSummary End Sub But on opening the workbook it gets stuck in a loop

Hi Skip When I copy your code and paste into my workbook then test it by say adding a value into one of the cells in column E nothing happens, no recalculation or error message. I have checked the options and it is set to auto calc.

I'm quite new to this VBA stuff and am obviously having difficulty understanding the different worksheet functions and where to place my code. I have a Summary Worksheet which (each time the workbook opens)I list in column A every worksheet name along with the sum of each corresponding...

Firstly thanks Skip my typo's caused by tierdness were the cause of my problems so I started a fresh this morning with your code suggestions and all worked well. Cheers for the reply Yooneek

Hi Skip I did mention earlier that I am happy to provide you with a copy of my workbook but do not know if either, this posting forum facilitates the uploading of a file from my PC or you would even wish to view it, as I know that you guys prefer for us minions to try and use our gray matter...

Hi Skip Sorry but I, obviously incorrectly, assumed from my reply to your earlier 4 questions that was giving you a picture. I am happy to provide you with a copy of my workbook but do mot know if either, this posting forum facilitates this or you would even wish to view, as I know that you...

Hi Dave & Skip The spreadsheets are still not performing. Any further suggestions guys ? Hey there's a star riding on this .....

Hi Dave Sorry. I created My typo error when pasting code into the forum. & should read as "AND" Cheers Colin

Hi Skip Firstly sorry once again for not making things clearer but just so that the active ws is comparing the relevant row/column on the summary sheet I ammended the line If .Cells(30, 16).Value < Worksheets("Summary").Cells(3, 10).Value Then To read If .Cells(30, 16).Value <...

Hi Skip Just to clarify I meant to say "On Error Resume Next" not continue Cheers Colin