Results 1 to 3 of 3

Find Text, Select range below, copy, paste to new work sheet

Threaded View

  1. #1
    Registered User
    Join Date
    03-10-2008
    Posts
    9

    Find Text, Select range below, copy, paste to new work sheet

    Hi All

    I have a workbook with several different sheets. I need VBA code to select worksheet title "Forecast Sheet" find the cell the contains the text "TOTAL PROJECT SUMMARY:" in column "B". This Summary is located on a different row each workbook.

    Copy this cell and the following 5 rows below as well as data from these same rows but in columns X & Z

    Copy and Paste to worksheet titled "Variance and Exec Sum" 2 rows below a cell that contains "Budget Incl:VO's (Hours)"

    I have attached a work sheet for example

    I am very new to VBA and forums, so please let me know if i have done wrong

    Cheers

    .
    Attached Files Attached Files
    Last edited by kim5012; 04-11-2011 at 09:13 PM. Reason: Incorrect Column Reference

Thread Information

Users Browsing this Thread

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

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