HELP! Paste in values in every 5 cells/paste into only visible cells
Hi everyone,
Please see my upload. I want to replace the numbers in red in the top tables with the red numbers in the tables below.
When I hide cells for the top tables and try to do it that way, I can only select/copy but I can't paste back in after I replace the numbers.
Also, I would prefer not having formulas with the end product.
Book1.xlsx
Thanks in advance!
Regards,
HC
If you dont want formulas, the only other option (that I can see) is to use VBA
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I am confused by your explanation. When I look at your sample, it appears that the numbers in red in the top table already contain the values for the bottom table. What am I missing here?
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
That was my thought too, AlanOriginally Posted by alansidman
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks