paste values

  1. I

    Loop through list of inputs to two cells, calculate workbook and record output to next line of output sheet

    I have two list of inputs one column for postcodes (=input!A1) and one column for quantities (=input!B1). I want to take the first postcode, enter it into a specific cell (START HERE'!$E$11),then enter the first quantity into a specific cell (=SITE COMPOSITION'!$D$33), calculate the workbook and...
  2. S

    Pasting Values using "Private Sub Worksheet_Change(ByVal Target As Range)"

    Hey all, Very novice when it comes to VBA, but I'm pretty good at copy/paste and brute forcing until something works! I managed to come up with this code that allows multiple values to be selected from drop downs (target.column section) as well as copying and pasting a row from an "Open" tab to...
  3. K

    VBA code to paste values of specific cells onto next empty row on another sheet

    I can't figure out how to edit this code to paste values. I've search so many forums. Can anyone help? Sub SUBMIT() ' ' SUBMIT Macro ' ' Dim ws1 As Worksheet, ws2 As Worksheet Dim DestRow As Long Set ws1 = Sheets("Entry Form") Set ws2 = Sheets("Reconcile") DestRow =...
  4. F

    Basic/Novice Help w/Pasting Protected Data to Another Sheet

    I am trying to copy and paste rows from a 18MB .xlsb protected and heavily filtered -- from column N to column EZ. I want it to paste into a 998kb .xls file. I can't remove the formatting otherwise certain cells, (based off of dates generated from an external application) -- or It will...
  5. T

    Yes no continue box with pasting values in to visible cells

    Wondering if anyone can help. I need help to create a macro for putting an "x" value into the visible cells i've filtered on a column. Since the column may not be the same on each sheet I'd like a pop up message to ask Yes or No to ask if the correct cell is selected at the top of the column...
  6. Y

    Force paste values

    I'm trying to force users to paste as values to preserve conditional formatting in the workbook. The following works for numbers but can someone please assist me in how to modify the code for pasting unformatted text (ie. from the internet) - at the moment this is returning an error because i...
  7. D

    find all values corresponding to each values

    hi all, I want vba code for following activity. Sample data is provided below. Copy each value in 'Find value' column and find all in column 'For Topic 1'. Paste the find all values in the column 'Topic 1'. Repeat this activity for all column Topic 1 to 4. <tbody> Find Value Topic 1 Topic 2...
  8. C

    VBA to transfer data from one sheet to another

    Hi, I'm looking for some vba help. I have an excel forecasting file that I'm working one - on one sheet (bulk) I have data for about 200 products on which I generate different forecasts. The other sheet (single) provides a graphical view for one product - the user selects which product they...
  9. J

    Macro to Copy and paste as value to cell A13 from a column in the next sheet and save each iteration as a pdf

    I have come across a system that requires a significant amount of work hours that I am trying to improve. I have automated the process to now only require the copy and paste of one cell (from an adjacent sheet titled 'Input') to autofill a form. In this case it is being copied to cell A13 of...
  10. S

    Paste Values rather than formula VBA

    Hi, I have some code where its picking data from one sheet and dropping it into another. However i just have a small issue with one piece as its pasting the actual formula rather than just the values. can someone advise with what I am missing or what I need here to do it? Sub Copyover...
  11. R

    VBA Paste Special and finding the next empty row

    I'm trying to create a master spreadsheet that collates worker timesheets from 100+ workers, onto a single master spreadsheet(pasted to 1 sheet, not to separate sheets). I've managed to get it to the point(with a jigsaw of borrowed code), where the timesheets do paste in to the one master...
  12. L

    VBA paste values into last empty row of a table

    On the tab "Instructions" I would like to have a module button. When you click the module button, I would like the following to happen on the tab called "LPA Database Scores Raw Data": There are two scenarios: First scenario: If F5 = "1" on the "Instructions" tab Copy B126:BO126 Paste as...
  13. J

    Loop not working - paste values on worksheets

    Hello, I am using the following macro to paste values on all worksheets that begin with "Labor BOE". Loop through worksheets and find those that start with "Labor BOE..." Select all cells Paste values (Alt+E+S+V) Unfortunately, it is not looping through my worksheets and doing this action to...
  14. J

    Issue with Array Formula Technique - Extract Unique List with VBA

    Hello, I am trying to find a better way to accomplish this task. I have a template worksheet that is copied multiple times (renames copies "Labor BOE X of N), then a "template table" is copied/pasted to each new sheet multiple times. There are array formulas in the first row of this "template...
  15. J

    Find Text (multiple times) in column C - insert array formula - drag down - paste values

    Hello, I am looking for a macro to search column C and insert an array formula one row below every occurrence of "Resource Description." Then, in column A of each row that a formula will be inserted, there is a number - which calculates how many rows to drag this array formula down. After the...
  16. J

    Insert "N" columns between Column B and C. Copy Range. Transpose. Paste Values

    Hello everyone... I am attempting to come up with a code to do the following . Any thoughts/guidance would be much appreciated! On Source_Sh ("SOURCE"): In column E (from row 9+)...I have a list that the user will input values - which will become column headings In cell $I$23 I have a count...
  17. 9

    Posting Values and Formats with VBA

    I need to take the formats from one sheet and copy to another sheet and the values of the original sheet and post to a separate sheet. All my info is on sheet 2. I need to post the formats to Sheet 1 and the values to Sheet 3. This is what I have but it doesn't work...
  18. J

    Copy Paste Formulas and Format - Not just values

    Hello, I am having a bit of trouble getting my code to copy/paste everything (formula and formatting) from the "Template Tasks" worksheet - opposed to just values. I think it should be a quick/easy adjustment, but I haven't been able to figure out how to modify. Any assistance would be...
  19. M

    pAsting values vba

    Hi Can I change the below to paste values only as links are being copied. ' copy cells selected in the new sheet on last line Selection.Copy Destination:=Sheets(1).Range("A65536").End(xlUp)(2) Thanks
  20. J

    Paste values based on a condition to next availble row in different sheet

    Hello, I'm fairly new to code but can usually problem solve my way to getting it to do what I need it to. I have been trying for days and have not had any success modifying scripts to get them work. HELP! This is what I'm trying to accomplish: 1. Copy "A4" and "B4" in sheet "DataEntry" 2...

Watch MrExcel Video

This Week's Hot Topics

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
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 "".
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