Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. scribbler99

    EXCEL AVERAGEIF FORMULA

    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...
  2. scribbler99

    EXCEL AVERAGEIF FORMULA

    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...
  3. scribbler99

    COMBINING VLOOKUP & HLOOKUP PROBLEM

    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...
  4. scribbler99

    VBA Force Recalculation of Workbook

    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...
  5. scribbler99

    VBA Force Recalculation of Workbook

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

    VBA Force Recalculation of Workbook

    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
  7. scribbler99

    VBA Force Recalculation of Workbook

    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.
  8. scribbler99

    VBA Force Recalculation of Workbook

    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...
  9. scribbler99

    Excel VBA Force Change event

    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
  10. scribbler99

    Excel VBA Force Change event

    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...
  11. scribbler99

    Excel VBA Force Change event

    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...
  12. scribbler99

    Excel VBA Force Change event

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

    Excel VBA Force Change event

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

    Excel VBA Force Change event

    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 <...
  15. scribbler99

    Excel VBA Force Change event

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

    Excel VBA Force Change event

    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...
  17. scribbler99

    Excel VBA Force Change event

    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...
  18. scribbler99

    Excel VBA Force Change event

    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...
  19. scribbler99

    Excel VBA Force Change event

    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...
  20. scribbler99

    Excel VBA Text To Columns Problem

    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...

Part and Inventory Search

Back
Top