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 Rhinorhino 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: *

  • Users: Airbisk
  • Content: Threads
  • Order by date
  1. Airbisk

    Change Event - Multiple Validation Checks

    Hi, I have been trying to write a change event procedure that looks at a range of cells and checks on whether the cell = "On Hire Previous Year" or is between a date range (Named Cells FYSD and FYED). If either are TRUE then to move to the next cell and if FALSE display a message box. I have...
  2. Airbisk

    Changing Text Box Reference

    Hi, I have a sheet called Main with about 50 text boxes that have a formula that links a value from another sheet (e.g. =References!A11) I have some text boxes (buttons) that run a macro that populate the 50 text boxes with different values. (The buttons used are for Name, Location and Age)...
  3. Airbisk

    Spreadsheet cannot close until certain cells are completed

    Hi, I have a spreadsheet that will be filled in by a host of users, currently there is data validation on most of the cells. When I tested the validation, it still allows the user to delete data that meets the criteria and then enter data that bypasses the validation. What i wanted to add was...
  4. Airbisk

    Need Help - Searching Column

    Hello, I have the code below that searches for a value and colours the row. Could someone please adjust so that it only searches Column M. Sub ColorRow() Application.ScreenUpdating = False Dim r As Range For Each r In ActiveSheet.UsedRange If LCase(r.Value) Like "*/*" Then Range("A" & r.Row...
  5. Airbisk

    Set Variable to Cell Location and Incorporate into Formula

    Hello, Could someone kindly help me complete this procedure please. I have set a variable to the ActiveCell and I wish to pick up the cell reference (eg E3) rather than the value. The procedure below works but brings back the value rather than reference. So the cell formula will look like...
  6. Airbisk

    Multi Lookup - Another Approach

    Hi, I have a spreadsheet that uses the formula below to look at four criteria and return the value where all four match. I am now trying to incorporate this into a larger spreadsheet where this formula (adjusted to work) will appear on every line (approx 5000). I have changed it to work but...
  7. Airbisk

    Combining 2 Searches - Then Copy Entire Row

    Hi, Presently I have 1 button that has the macro below assigned which searches Site Print Column A and matching the value with Cell F9 in Criteria and then pulling the entire row into Search Results. Sub accountmoving() Dim c As Range, d As Range If Range("F9") = "" Then MsgBox "Please...
  8. Airbisk

    Search on Date Range - Copy Row with matching Date

    Hi, I found the program below and have amended it to suit the needs. The needs have changed. Currently the program would look at the date entered in F15 and pull into Search Results all the rows where that date appears in Column I of the Site Print Worksheet. Now a Date to field has been added...
  9. Airbisk

    Search on Date Range - Copy Row with matching Date

    Hi, I found the program below and have amended it to suit the needs. The needs have changed. Currently the program would look at the date entered in F15 and pull into Search Results all the rows where that date appears in Column I of the Site Print Worksheet. Now a Date to field has been added...
  10. Airbisk

    Unprotecting hidden worksheets

    I have called the code below within a written macro. The code has caused some problems after protecting some hidden worksheets that require to be unprotected. Could you help me by pointing me in the right direction/code so that I only protect the visible sheets in my workbook. If you require...
  11. Airbisk

    SUMIF - Alternative

    Hi, Have a spreadsheet which pulls information from another spreadsheet using the following formula =SUMIF('[Week 42 Roster.xls]ON CALL'!$I$4,$B132,'[Week 42 Roster.xls]ON CALL'!$I$8) The data pulled through is a text selection from a drop down list but doesn't pull anything through. Does...
  12. Airbisk

    Linking to another spreadsheet only works when other file is open

    Hi, I have a spreadsheet that as a few hundred links pulling data in from a few other spreadsheets. Some of the links work without the linked spreadsheets being opened, these have links like... ='T:\Torrent\qpulse\Weekly Roster Planners\Bolton\[Week 42 Roster.xls]PAYROLL SUMMARIES'!$B$6...
  13. Airbisk

    Group By - Sum with Date Range

    Hi, I have a table that contain jobdate, staffname, overtimehrs, standardhrs field. Now I can sum the number of overtimehrs and standardhrs using Group by and Sum but when I add the criteria for a date range to be selected (Between [Start date] and {End Date]) the query returns multi lines for...
  14. Airbisk

    WEEKDAY Formula returning #NAME?

    Hi, The formula below should look to see if today is a Monday and if cell K2 is less than 3 return 1, if not then return blank. =IF((AND(WEEKDAY(TODAY())=2,K2<3)),1,IF(K2=1,1,””)) All I get back is #NAME? and I don't understand why, can anyone guide me in the right direction. I'm using Excel...
  15. Airbisk

    Rounding Cell value in the same cell

    Hi, If I enter a value into a cell I want that value to be rounded up to the next hundred (e.g 530 becomes 600, 201 becomes 300, 998 becomes 1000 etc) Can esily be down if I had another colum and used ROUNDUP but is there a way for formatting a cell to automatically change it when entered? Thanks
  16. Airbisk

    Help:- Excel 2003 Pivot Table VBA

    Hi, I have amended the code below to give me a nearly desired pivot table. Sub Pivot4() Dim PTCache As PivotCache Set PTCache = ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:="Data!R1C1:R65536C15") Set PT = PTCache.CreatePivotTable(TableDestination:="Pivot!R1C1"...

Part and Inventory Search

Back
Top