Best way to force a Paste Values only

P

Plumbstar Tom

Board Regular
Joined
May 26, 2010
Messages
69
Hi all

My sheet has a row of 36 cells (3 years of months)

Each month has a value generated below it from a table and vlookup

I need the user to copy the data from here and paste to another sheet but simple copy and paste defaults to copying the formula

Any ideas on the best way I can copy the values only?

I do try and avoid VB as I am far from an expert but if thats the route then so be it

Tom
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Sort by date Sort by votes
Without using VBA scripts, you can just select your cell that you want the values in and link it to the cell on the other sheet.

So in your destination cell you type the = key and then select the cell that contains the value that has been updated and press enter.

This will work if the source and destination cells are always the same cells.
 
Upvote 0
Hi

That wont work for me as the value in the source cell will change

What would be the VBA Script?

Basically the user in puts 3 values in a sheet and a list of 36 are returned

these 36 values needs to be copied and pasted into another sheet but default is to copy the formula I just want values
 
Upvote 0
One way you might be able to force it is if the sheet is protected and the cells formatted to 'hidden', when you copy/paste, it only transfers values and number formats by default.
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question
Need VBA to automatically copy paste rows based on dates of current month.
2
Replies
11
Views
438
pk970
P
B
  • Question
Copying data from a year tab and pasting into month tabs
Replies
2
Views
263
B-radK
B
I
  • Question
VBA - Copy Sheet from a workbook saved as a date - paste to specifically named sheet in another workbook based on the date
Replies
2
Views
421
Insurance Dave
I
S
  • Question
Repeating a pivot table many times and changing only one column -- are there more efficient approaches?
Replies
0
Views
260
sschaefer
S
S
  • Question
VBA Challenge
Replies
2
Views
327
SnowyBry
S

Forum statistics

Threads
1,216,514
Messages
6,131,105
Members
449,619
Latest member
AntoineMaubon

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