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 TouchToneTommy 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: julesl
  • Content: Threads
  • Order by date
  1. julesl

    conditional vlookup formula

    Hi I have a spreadsheet containing 2 worksheets and I need to copy data into the second worksheet based on certain criteria. The formula I am trying to write is as follows:- Look up A2(id) from Worksheet 2 in Worksheet 1 (A2:N691) and bring back the contents of cell I2 if K2 = "Main" (in...
  2. julesl

    Delete rows in excel based on day and date

    Hi I have a spreadsheet which contains 13 columns, one of which is a start date (column D). The spreadsheet will contain rows with varying start dates and I need to remove all dates that are before yesterday's date except on Monday's when data for the previous Friday, Saturday and Sunday should...
  3. julesl

    Copy a formula in excel to the last row of data

    Hi I've created the macro below using VBA in excel and I'm trying to get the formula to copy to the last row of data within the spreadsheet rather than to a specific point. Sub CopyForm() ' Range("N1").Select ActiveCell.FormulaR1C1 = "RR Termination Date" Range("N2").Select...
  4. julesl

    Automatically deleting rows in excel

    Hi I'm trying to automatically delete rows in excel which meet certain criteria. I have a spreadsheet with 13 columns and column F is an indicator which contains either "mortgage" or blank. I have created the following code using Thread 707-687994:- Sub deletenonmort() lRow = Cells(65536...
  5. julesl

    Query to count duplicates and non duplicate

    Hi I've built an access database and I've been asked to build the query below, but I'm not sure how to, as my access and SQL skills are limited. I have the following list of items and I need to list all the non duplicates from column 1 (REF), then count the duplicates from column 1 (REF) and...
  6. julesl

    Inserting data from a Data Input Form in a word document

    Hi I have next to no knowledge of VB and have volunteered to create a template containing several input forms. I have designed the forms in VBA (which include check boxes and combo box) but I have no idea how I’m going to get the data from the forms into the Word document. For the form...

Part and Inventory Search

Back
Top