+ Reply to Thread
Results 1 to 3 of 3

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

  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

  2. #2
    Valued Forum Contributor
    Join Date
    06-17-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003,excel 2007
    Posts
    678

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

    see whether this macro helps. Cosmetic changes you can make later.

    Please Login or Register  to view this content.

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

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

    Thanks Works well and i have been able to tweak it but when it goes to paste the values from Columns X & Z, because the orginal values are formulas when it Pastes special into the otherworksheet the formula appear rather then the value.

+ Reply to Thread

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