+ Reply to Thread
Results 1 to 1 of 1

copy a row of data to new sheet based on a criteria using cell.offset

  1. #1
    Registered User
    Join Date
    10-12-2010
    Location
    tallahassee
    MS-Off Ver
    Excel 2003
    Posts
    1

    copy a row of data to new sheet based on a criteria using cell.offset

    I have been asked to modify an existing excel.macro that someone else wrote. The data is a list of devices, their down time and other data. There is a blank summary shhet with a button to invoke the macro. The macro asks for user input of a bench mark time in hours via msgbox, and then it sums up all the downtime for each device and if the total down time is over the bench mark, the device and it's total is on the summary sheet, with the individual down times for each device. What I have been asked to do with the macro is to copy the entire row for each individual down time on the summary sheet.I can't figure it out.
    I attach the spreadsheet

    Please Login or Register  to view this content.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1