paste values

  1. B

    Macro to paste values for all files in folder

    Can anyone please help me with a macro that I set a folder path and takes all Excel workbooks in that folder and Pastes Special: Values on the whole thing, then saves and closes the workbook and moves onto the next until all the Excel files in the folder are just values. Thanks for all your help!!
  2. B

    Paste Values instead of pasting formulas

    I found a specific formula for collating data from closed worksheets and it works great with one exception, and I'm sure it's a quick fix but I'm new to VBA. I need to formula to paste values instead of pasting the formulas. I'm sure it's a change to one or two lines and I will put the formula...
  3. excelsupernerd

    My PasteValues Macro!

    Here's how I've implemented a macro shortcut that will enable you to paste values only, even if it's from an outside application! Sub pasteValuesOnly() ' ' Keyboard Shortcut: Ctrl+Shift+V ' This allows the macro to pass on to ' the next method if it's text from outside of Excel On...
  4. O

    Copy & Paste Values In Next Column From B2

    Hi All, I have two worksheets: "Pipeline" "Weekly Pipelines" I need to copy data from B1 to B4 on "Pipeline" and paste values to the next available column after B2 in "Weekly Pipelines". Would anybody be able to help me with the code as I have tried lots of different codes, and nothing...

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