copy paste values

  1. S

    VBA Code to Copy Dashboard Date Data, Lookup that Date on YTD Data tab, and Paste Value?

    Hello, In essence, I'm trying to make a macro that reads the data from sheet "Dashboard" that corresponds to a specific date in cell C4 (in this example, focusing on the range of C9:V9), have it lookup that C4 date in column B of "YTD Data" sheet, and if found, Copy/Paste value the contents of...
  2. D

    SUMIF Copy & Paste-Value

    Hi guys, new to VBA and only my 2nd post. Not having much luck, hoping you can help: I essentially want to achieve a SUMIF combined with a copy & paste-value. I want to check a date ('T.O.P Summary'!$B$2) and look it up against a column of dates in my data (Customer1!K:K). When it finds the...
  3. L

    Optimize/ Simplify Macro

    Sub Import() Application.ScreenUpdating = False 'Import basic stuff 'Network Sheet8.Range("U2:U3001") = Sheet3.Range("AB2:AB3001").Value 'Network Addon Sheet2.Range("I5:I3004") = Sheet8.Range("V2:V3001").Value 'FAN Sheet2.Range("B5:B3004") = Sheet3.Range("A2:A3001").Value 'BAN...
  4. B

    CopyPaste Values macro

    Hi all, I am looking for a quicker way to paste values from the clipboard. Does anyone know how to set this up so I can assign a hotkey to this procedure?

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