Search results for query: *

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

Hi Skip The code you provided doesn't quite hit the mark yet but that is due to me not providing you with the complete picture. On my summary worksheet each of the products has a seperate target value starting column 10 row 3, row 4 etc. also the line of code I highlighted in red causes an...

Hi Skip I have read your reply, and thought I understood it, but after replacing my code with yours I now do not get any formatting on my worksheets at all. Please can you take a look I applied the following code to each worksheet (except the STICKS as that has 3 more rows than the others so...

Hi Skip Firstly, tahnks for a quick reply. I have Sheets No's which contain the code are 2,3,4,5,7,8,9,10,11 The code in each sheet is as follows. Sheet7(HEARTS) Private Sub Worksheet_Change(ByVal Target As Range) If Worksheets("HEARTS").Cells(22, 3).Value <> "" And...

Please can anyone enlighten me with the following problem I have. Firstly I have to say I have browsed this forum and the web with out success. I have a number of worksheets in my Excel workbook and each one is linked to my "Summary" worksheet. Each of them has a small amount of code contained...

Sheets 1 to 9 contain following (as well as other info) but there could possibly be more sheets added in future. Job No. Start Fin Time Staff_Ref 1234 08:00 08:45 00:45 9355,9356,9357,9988 1237 09:00 09:30 00:30 9355,9356,9357,9984 1241 09:30 10:15 00:45...