I want a macro to copy three cells into a varying number of rows. The number of rows changes each month. see the attached sample. I want to copy cells I2, J2 and K2 to columns B, C, & D the number of rows shown in cell N4.
This is the opposite of the macro I was working on last night.
Thanks
try this:
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thank you alansidman. The macro works. I had to change the PasteValues to PasteAll as I want the formulas in the cells. I have several macros but never have used DIM so I cannot follow your logic. But that is ok as it works for what I need.
How do I post that this thread is solved? Also I could not find the * to click.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks. The Star is at the bottom of the thread and says Add Reputation.
When you use Option Explicit, you have to define your variables through Dimension (Dim) statements. Doing this helps when you need to debug your code.
Again thanks. I found the thread tools and marked this thread solved. I also found the star. I was looking too far down.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks