VBA codes to copy and save documents to values

B

b13

New Member
Joined
Jul 25, 2011
Messages
46
Hi guys i need help,
I had this document that in one sheet(1) it will be used time to time because of the months that past by. In the other sheet(2), the data there always change based on the months but Sheet(1)'s formulas are based on the Sheet(2)' data. The problem is i need to minimize the worksheet's file size that is why i'll just delete data in sheet(2) then replaced it with the current ones that i needed, but before i erase the data in sheet(2) i must first copy and save to values all data in Sheet(1) then create again a formula. Is there anyway that i can speed up this routine?Maybe in just one click the whole column will be saved as values.
Thanks a lot...;)
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Sort by date Sort by votes
Record a macro of all the steps you do and paste the code here. Then explain what part of the macro you want to change.
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question Question
How restrict copy data from form to sheet based on five days within current month
Replies
3
Views
110
Ali M
A
R
  • Solved
Excel VBA to filter by unique value, copy paste into new workbook and save
Replies
2
Views
861
rittersportyummy
R
R
  • Solved
Export excel file as PDF into a targeted pc folder based on cell value
Replies
2
Views
272
Ramadan2512
R
N
  • Question Question
VBA to add title from formula to a save as name
Replies
0
Views
138
NKUNZI
N
E
  • Solved
Run code after set period of time
2
Replies
14
Views
327
EssKayKay
E

Forum statistics

Threads
1,224,600
Messages
6,179,836
Members
452,947
Latest member
Gerry_F

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top