+ Reply to Thread
Results 1 to 2 of 2

Pasting problem with hidden/filtered cells

  1. #1
    Registered User
    Join Date
    12-17-2007
    Posts
    1

    Question Pasting problem with hidden/filtered cells

    I am having a problem that deals with pasting on a filtered column.

    I have this big spreadsheet and I have to add changes to it that I get from another spreadsheet. What I have done is put auto filters on the column headings. Then I filtered to only show those that have start dates. What I would like to do is paste in the column of changes into a column on my original spreadsheet. When I try to do this, the changes ended up being pasted in both the visible and hidden cells, which messes everything up.

    Can anyone help me figure out how to paste only in the visible cells?

    I am using Excel 2003.

    THANK YOU!

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481
    Check out this example
    http://www.excelforum.com/attachment...4&d=1173865150
    enter these values in the apropriate cell
    pickles
    rice
    TOMATO
    CHEESE
    OLIVES
    http://www.excelforum.com/showthread.php?t=592750

+ 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