+ Reply to Thread
Results 1 to 2 of 2

Paste Back to Filtered Sheet or Alternative?

  1. #1
    Registered User
    Join Date
    10-02-2013
    Location
    Northern AZ, USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Paste Back to Filtered Sheet or Alternative?

    To keep it short and simple... I copy data from a autofiltered MainData sheet to a TempSheet. I then use the TempSheet to populate a listbox on a user form. The user then adds or changes a (completion) date and the data is saved back on the TempSheet.

    I've can find no simple way of writing the data/date back to the original filtered main data sheet in the original column /row. I've searched and searched and am about to pull my hair out. It's only one column and will never exceed 20 rows. Surely this is a typical process. I'm looking for the best way to accomplish this. Some ideas I've researched and considered are...

    1. I've worn out trying via using SpecialCells & xlCellTypeVisible. Maybe I'm missing something?
    2. How about adding row numbers and using the Find Method to copy/write back to the column on correct/original rows?
    3. Counting rows, don't know if possible to set/select the first 20 rows that are visible and copy the dates back that way?
    4. Some creative sorting so data comes from contiguous rows? (Not sure if this is even a possibility).

    Or some other way I'm missing entirely? I'm fairly new to VBA programming and this is my first post here. I've come a ways with my current project and did so with persistence, research, reading and lots and lots of trial and error like most folks, but this has me at a standstill. Any suggestions, ideas, examples or a pointer in the right direction would be much appreciated.
    Thanks in advance for any input.
    Marc

  2. #2
    Registered User
    Join Date
    10-02-2013
    Location
    Northern AZ, USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Paste Back to Filtered Sheet or Alternative?

    No one? I noticed the similar posts on this subject are also unanswered. I take it that means you simply can't?

+ 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. Paste from unfiltered sheet into filtered one
    By shootingstarz in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-28-2013, 07:33 PM
  2. [SOLVED] Copy and paste filtered rows in new sheet
    By rz6657 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2013, 07:05 PM
  3. Paste variant onto filtered sheet
    By phil_b in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-21-2010, 11:35 AM
  4. Paste Values To Filtered Sheet
    By LB79 in forum Excel General
    Replies: 0
    Last Post: 10-31-2008, 07:47 AM
  5. Paste special into a filtered work sheet
    By SmithDelgado in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-20-2006, 01: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