I wants to Copy Paste all the data of worksheets as Paste Special Values EXCEPT the cells which Having "=SUM" formula.
Please help.
I wants to Copy Paste all the data of worksheets as Paste Special Values EXCEPT the cells which Having "=SUM" formula.
Please help.
Attaching a sample workbook enables others to work on your problem:
To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.
Click on GO ADVANCED and click "manage attachments" to open the upload window.
To add a file to a post
Please refer the file attached.
There are many formulas in the worksheets. I want everything except the cells which contains formulas which starting from "=SUM" on every worksheet to be paste as values. Thanks
Last edited by AliGW; 03-29-2018 at 03:07 AM. Reason: Unnecessary quotation removed.
You will need VBA to do this: Copy/paste everything except lines containing "Total" in column C (?)
Yes I need vba codes for this.
Wherever the formula starts with " =Sum " it should remain as it is, and all the remaining formulas should be copy and paste special as values.
FYI:
For "Grand Total" you could use ..
=SUMIF($A:$A,"TOTAL",D:D)
Copy across
Thanks but this is not what I exactly wanted. I require all cells to be copy and pasted as values, i.e. to convert formulas in those cells to text or number. (Except those cells in which formulas starting with SUM function/s).
YES .. I know: I was saying you could simplify the formula.
You need to move this thread to VBA/Macro forum.
How to move this thread to VBA/Macro forum? Do I need to re-post it?
Ha! Nothing like replying to a thread 13 months later.
SOLVED in this Thread : https://www.excelforum.com/excel-pro...ml#post4873867
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks