Results 1 to 13 of 13

Thread: Solved: in Excel 2007, pasting to visible cells only

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 03-14-2009, 09:08 AM #1
    K. Georgiadis
    K. Georgiadis is offline
    VBAX Mentor
    Joined
    Jun 2004
    Posts
    368
    Location

    Solved: in Excel 2007, pasting to visible cells only

    I have an 8700-row static data table with 9 columns. I want to filter the data by product and state and create new dynamic formulas for each/product combination and then copy them down to ONLY the visible rows that have met the same filter criteria.

    I checked with the Microsoft Communities Group and was told that Excel does not have a built-in function to paste formulas to visible cells only but that this can be accomplished with VBA code. Could you help me with this?

    Thanks in advance
    Last edited by K. Georgiadis; 03-14-2009 at 09:32 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules