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!

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

    Use a Macro to Select a Range based on blank cells

    I set up the following macro to open up corresponding files and copy them into a worksheet. Sub Run_Hedges() ' ' Run_Hedges Macro ' Macro recorded 3/15/2010 by Chris Vesta ' ' Keyboard Shortcut: Ctrl+h ' Range("B4:AT150").Select Selection.ClearContents Range("B4").Select...
  2. BetterBeef

    Calculate Total Hours Utilizing MIN and SEC Cells

    I am very close to solving this, but for some reason I just can't get the final detail. I have 6 cells that designated as shown below: L14 M14 N14 O14 MIN DAY 1 SEC DAY 1 MIN DAY 2 SEC DAY 2 P14 Q14 R14 MIN DAY 3...
  3. BetterBeef

    Combo Box in Excel

    I am used combo boxes in the past with Access but am not familiar with how they work in Excel. I have two lists in Column E and Column F of a worksheet called "Lists". I have a combo box in cell E2 of a worksheet called, "2009", that I would like to populate with the two lists. I would like...
  4. BetterBeef

    Copy a row of data and only paste the formulas into the next row

    Is there an easy way to copy data from a row and when you paste it, to only have the formulas paste, and not the raw data? For example, cell A1 had the number 5 in it, and cell A2 had the formula =A1+7, I would like to copy the the row into row 2, but when I paste it, the data in B1 would be...

Part and Inventory Search

Back
Top