copy values only

  1. P

    VBA Copying Rows based on Condition, copying the value only.

    Ok I do not use VBA pretty much ever, but was asked to add an "archive" feature into my workbook. Below is the code that I found online, it works, but it also brings over formulas and I am not too sure what I need to do to adjust it. So in column "z" I have a "True" or "False" condition...
  2. W

    Copy value of every 3rd row into columns

    Hi, I'm trying to copy the values from every third cell into a new column. I've looked at examples and tried both the INDEX and MOD functions to no avail. Please help. https://drive.google.com/file/d/0B-bGMjKaL94hOXIxSHBDODhPZjg/view?usp=sharing
  3. frabulator

    Copy data from a folder of closed workbooks to a active workbook

    Hello all, Long story short, I have been looking for weeks on how to copy a range of cell's values from a folder full of closed workbooks into the active workbook, and then have it paste the values from each in order starting at "A2" on the active. Sadly, I have pulled up short on everything...
    • frabulator
    • Thread
    • active workbook closed workbooks copy values only folder lookup module
    • Replies: 2
    • Forum: Excel Questions
  4. M

    Automatticly copy values only

    Hello everyone, I have a question, how can I automaticly Copy values from A1:A50 to B1:B50 (values only) So I have a form like this: A1 (2-1) A2 (3-1) etc.. And I want: B1 1 B2 2 etc.. So I can hide column A and users will not see any formula. Kind regards, Miicker

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