+ Reply to Thread
Results 1 to 3 of 3

Pasting data to visible cells only

  1. #1
    Registered User
    Join Date
    05-23-2011
    Location
    Dammam
    MS-Off Ver
    Excel 2003
    Posts
    7

    Pasting data to visible cells only

    Hello!
    I've a worksheet where the engineers are updating their activities (now the shared folder is not working). I get the feedback from the engineers, filtered on their names. I want to update each engineer's feedback in to the master file which is the same, to filter on submitted engineer name and paste data. I know to copy only visible cells using "Go to-Special-visible cells only" command. How can I exclude/ignore the hidden rows and paste only on visible cells?

    Regards,

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,278

    Re: Pasting data to visible cells only

    Instead of every time copy paste to another sheet, why not using dashboard to extract required data only. If you provide / attach sample file its very helpful.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Registered User
    Join Date
    05-23-2011
    Location
    Dammam
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Pasting data to visible cells only

    Please tell me technique to exclude hidden cells while pasting.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pasting Into Visible Cells Only
    By Zach Boyer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2016, 09:39 AM
  2. Pasting into only visible cells
    By Cheeseburger in forum Excel General
    Replies: 6
    Last Post: 03-28-2013, 02:49 PM
  3. [SOLVED] Copy/Pasting Values from visible cells (using autofilter) to visible cells
    By evakotsi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2012, 07:49 AM
  4. Filtered data pasting - visible cells only
    By olechkq in forum Excel General
    Replies: 1
    Last Post: 03-08-2012, 03:41 AM
  5. Pasting to Visible Cells
    By Trying in forum Excel General
    Replies: 0
    Last Post: 01-24-2010, 08:39 PM
  6. pasting to visible cells only
    By snoozy71 in forum Excel General
    Replies: 1
    Last Post: 03-22-2009, 12:26 AM
  7. [SOLVED] Pasting Visible Cells
    By LyndieBee in forum Excel General
    Replies: 1
    Last Post: 02-17-2006, 02:25 PM

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