#copy&pastevaluesonly

  1. V

    Copy each sheet to new workbook, paste values and save to specific folder

    Hi all I've been looking for threads that could help but haven't found any that I've been able to use. My problem is that I have a workbook with multiple sheets, each sheet has formulas to get info from 2 other sheets in the workbook. I need to copy each sheet (except for the two with the info)...
  2. M

    Copy items from sheet1.range(X:X) to next empty cell in range located in Sheet2.

    As the title says I have a sheet1 and sheet2 where I neeed to check if in range H193:H271 item count is more than 0 and if yes, then copy this value + two offset values to the left, into sheet2 in empty cell in range B11:B30 and C11:C30 and if that range is full then copy those values into...
  3. B

    VBA copy filtered data with matching headers, go to sheet2, identify last row and paste each matching headers data in a new row below it

    Hi Guys, I am trying to copy filtered data with matching headers, go to sheet2, identify last row and paste each matching headers data in a new row below it, it doesn't work as expected. It copies all data and pastes it in order, does anyone know how to tweak the code to only paste matching...
  4. A

    multiple open workbooks' data copy and paste to one workbook based on reference match

    hello. I am new to this forum as much as I am new to Excel VBA. Basically, I am trying to do copy and paste data range to 'already formatted excel file with lots of tabs'. I could do this with manually but problem is this is really time consuming and tedious job. When I export excel data files...
  5. P

    Macro to copy and paste a range of values numerous times

    Hi All, I would like to have some help regarding the following macro. I would like to copy a range of values in a certain column and paste it down the same column 365 times, with offsetting one row. For an example; 1) Copy A2:A682 (This will always be the same) 2) Paste it in A684:A1364 3)...
  6. N

    copy and paste VALUES ONLY, not the formulas.

    Hello, The current code copies and pastes the results with formulas. Then, it gets really tedious to export the worksheets to a new workbook as the worksheets lose formula references. I need to be able to copy and paste VALUES ONLY, not the formulas. See the above VBA code. Please help...
  7. N

    Help with Excel VBA in Copy and Paste Values Only, not the formulas

    Hello, The current code copies and paste the results with formulas. Then, it gets really tedious to export the ONLY the values, not the formulas. See the below VBA code. Please help. Thanks, Nes ================= Sub CreateSheets() Dim rng As Range Dim wkb As Workbook Dim wks As Worksheet Dim...

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