•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Paste content into every other cell
Our take
Pasting content into every third row can be a challenge, especially when working across different files. If filtering and selecting visible cells didn't yield the desired results, don't worry—there are alternative methods to achieve this. One effective approach is to use a formula or a script that can automate the process, allowing you to seamlessly insert your data without the hassle of manual selection. Explore these options to streamline your workflow and ensure your data is organized exactly as you need it.
I want to copy a column of strings from one file and paste it into another file. The problem is that I want to paste the content into every third row (skipping 2 rows pretty much).
I tried using a filter to only show the row types I want to paste into (every 3rd row), selecting the cells I wanted to paste into, pressing ALT + ; to select only visible cells, THEN finally pasting. But it didn’t work.
Is this even possible? Or is there a work around I can use?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience