Hi all,
I have a big data file in Tab 1. Underneath the data, I have made some IF summaries etc. Now I think its better to copy them to a different Tab. How do I copy them to Tab 2, but keep having them referring to Tab 1?
Thanks in advance, I couldn't find it on the forum, because I'm not quite sure how to word it in english.
Kind Regards,
Michael
Hi,
Welcome to the Forum.
Seems you need to freeze your ranges that your formulas use. Can u post a desensitized version of your data file (with sample data of about 10-20 rows) ?
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
highlight what you want to move, then try CTRL X (cut) and then CTRL V (paste) or just enter
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks