Paste to Multiple Ranges

[jwk]

I've searched high and low, and can't find anything on this topic specifically.

What I'm attempting to do is take a source range, for example, A5:A99, and then paste it to multiple ranges. Destination ranges are on another workbook (which shouldn't matter), and are ranges such as A5,A40,A75,A110,A145, etc. The destination ranges are exactly 35 rows apart. Currently, we are copying the source range to an intermediate sheet, and through a macro, inserting 34 rows between each cell. We then take the range, A5:A3295, and paste it where we ultimately want the data to go. We are filtering the data right now, as the 1 rows that contains data, drives the other 34 rows to lookup values in other worksheets.

A few solutions i've thought up:

Working off the filter as where the data should be pasted, run the following macro:

Please Login or Register  to view this content.

This however, does not work, as the destination values repeat. The macro was recorded by using Ctrl-G, Special, visible cells only, then a paste special for values only, as the source is actually a formula of its own.

Source:
A5: Emp001
A6: Emp002
A7: Emp003

Destination:
A5: Emp001
A40: Emp001
A75: Emp001

I found that the code does work nicely, but only if you are copying one cell, not a range.

The other solution i thought of was to programmaticly paste the cells with 35 row between each pasted cell. This, however, seems quite complicated.

As to provide further background to what we're trying to accomplish, I'm an IT Admin, and our Bus. Mgr. is trying to summarize each employee's wages, insurance, 401k, etc. for a year over year comparison. He does not want me to access the worksheet (yea...) but fortunately, what he's trying to accomplish seems straightforward enough for me to recreate. The source data is generated from our accounting system. The destination is the report he has to fill out for review by higher ups.

Thanks for any help in advance.

[jwk]

- - Well Turns out my problem got overlooked and is now back so many pages on the forum, it will never be noticed. At least we tried. On a side note, the work around works for now, so cheers to anyone who goggles the topic of pasting into a filtered spreadsheet, i hope this helped.