Results 1 to 5 of 5

How to copy a value to an auto filtered column and only paste to the filtered rows in VBA

Threaded View

eacounts How to copy a value to an... 08-16-2012, 04:42 PM
FDibbins Re: How to copy a value to an... 08-16-2012, 05:27 PM
eacounts Re: How to copy a value to an... 08-16-2012, 05:43 PM
FDibbins Re: How to copy a value to an... 08-16-2012, 06:19 PM
eacounts Re: How to copy a value to an... 08-16-2012, 06:20 PM
  1. #1
    Registered User
    Join Date
    07-13-2010
    Location
    texas
    MS-Off Ver
    Excel 2007
    Posts
    4

    Angry How to copy a value to an auto filtered column and only paste to the filtered rows in VBA

    Hello Everyone,
    I am very new to VBA. I have a requirement from a client that I have to complete by Monday. I have a spreadsheet that could possibly have over 20k rows in it and approximately 20 or so columns. They want to be able to use the auto filter for any of the 20 columns to get the rows that they want to show on the spreadsheet. Once that is done they want to apply a factor or apply a date that the user will enter into another range on the sheet to ONLY the visible rows and into one specific color coded column. So I can't do a regular copy paste because it will paste the factor or date entry over all 20k of the rows even if they are not showing in the filter. If there is anyone who could assist me I would be grateful. I have been working on this for a while and It is due Monday.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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