copy and paste

  1. V

    VBA Macro to paste values from a list in multiple separate worksheets

    I have the an "Input" spreadsheet with a list of unique values. Then I have a series of worksheets that are identical templates. I want to past each unique value from the list on the "Input" sheet into the same cell within each of he separate worksheet templates. Ideally the macro / code...
  2. I

    Copy and paste VBA code including duplicate values

    Hi. So I have two workbooks here. I have attached screenshots of both. One is Pickorder. Column A lists the dispatch times. Column B has route codes. Column D has the dispatch areas. Column E has the dsp taking the route. For example, CX19 dispatches at 6:15:00, at STG.A01 for HIQL. I then have...
  3. I

    How to edit this copy and paste VBA code to not use a criteria if not found?

    Hello. I have this copy and paste code that copies cell values from one workbook to another. Copy from pickorder. Paste into wave planner. To match it up it gets the staging location in column D example, "STG.DD35" and the dsp in column E "M5DV." However sometimes this first sheet, referenced as...
  4. L

    VBA: Set active workbook when macro is run as 'thisworkbook'

    Hi There I have a workbook which is a newly opened excel workbook which is unsaved A user will paste data into this blank workbook and run a macro called 'termination' (which is residing in their personal.xlsb project) One of the actions of this macro is to open another workbook called...
  5. J

    VBA Copy and Paste Data from one workbook to another - specific columns

    Hi, I have a statement converted from pdf to excel. Unfortunately, the column headers above the data that I really need may lie on different rows, for e.g. row 17 or row 18. I have 3 columns I want to copy from the statement: Date (column B), Description (column C) and Amount (column D); then...
  6. M

    Record Macro to Copy & Paste as Values - paste into cells that might move up/down as rows above are added/deleted

    Hello! Can you help? This should be simple, right? I have two cells (eg. AC58 & AC59) with a % number in each. I need to copy & paste these numbers into the cells next to them (AD58 & AD59) - this is so I can re-use these numbers without creating a circular reference. When I do a simple...
  7. J

    VBA code to locate specific already filtered columns by name and paste into a new workbook

    Hi All, So to give some background, i have a large data set (60k plus rows and 90 plus columns) that i need to filter and create a new workbook using specific columns. The size of the file changes daily, and columns are taken out and added. So i had to keep updating the previous macro i had...
  8. D

    VBA Code but ignore sheet

    Hi all I have the following code which works well in part but Private Sub COPYTEAM() Application.Calculation = xlManual Application.ScreenUpdating = False Dim LastRow As Long Dim ws As Worksheet Sheets("Template").Visible = False Sheets("Team").Visible = True Call ClearTeam...
  9. A

    Copy and paste data based on text in cell next to it [VBA]

    I have some code that I want to check every cell in in the range “A3:AAA3” for a specific text. If the cell contains that text, I want it to copy the text in the cell on the right, to two rows above (see below for illustration): The copied text will be a date. This is what I have so far...
  10. B

    InputBox and Cut and Paste based on value

    Hi, I have a problem: I need to line the same people in column B and currently it looks like this person is always in one cell from A-H but not always in column B as desired. If this person is in for example column H then I have to move him/her to column B and person from column G to column A...
  11. B

    Copy Paste Between Workbooks VBA

    Hi Everyone, How do I copy and paste work between workbooks (I have a total of five open workbooks)? My Range will be unlimited such as : Rows.Count).End(xlUp)) I see people do two typically but I don't know how to write when there's more than two. I have one main workbook that I will be using...
  12. J

    VBA Copy and Paste Code with filename

    Hey All! I have my trusty old glorified copy and paste code but I am looking to link the line that has my Workbook name to a cell in one of my sheets. Can't seem to figure it out. Sub GrabIndEquity() 'Update Data Workbooks.Open Filename:= _ "T:\FILE1\FILE2\FILE3\FILE4\FILE5\DATABASE...
  13. P

    Copying yellow cells in a range to another column on the same sheet with VBA

    I have a dataset that contains yellow cells (each yellow cell represents the final treatment plant or TP in a flow path) from Range("A2: F841"). Since the yellow cells are spread out randomly among the columns A to F, I would like to use VBA to copy them all as a single range in column J. I am...
  14. E

    Using VBA to lookup a value and write back to that row in a different sheet

    Forgive me here guys. I'm completely self taught but have zero knowledge of visual basic and have come up against a problem that I believe can only be solved by visual basic I have a worksheet of customer information called "data" I then have another worksheet called "Agent View" The agent...
  15. S

    Copy Paste Running Data Macro

    Hello, I am building a customer login sheet/tracker. I have a tablet that I will be running the login sheet off of for the customer's to fill in their information and I have put a shape at the bottom that looks like a button. I want to add a macro to where when they click the button, it copies...
  16. K

    copy from main sheet to another sheet

    sheet 01 i want to copy this and paste sheet 02,sheet 03, sheet 04 . and at the sme time paste this heading is sheet wise SHEET 02, SHEET 03,SHEET 04 etc. for this pasting have any code...?
  17. B

    VBA - Appending one list onto another on different sheet

    Hi, I have two lists on two separate sheets and I am trying to append one list (ws6) to the other (ws). It should copy the relevant ranges per row in sheet ws6 and paste them into the relevant columns in sheet ws. Then it should add in two values on two columns to each appended row in sheet...
  18. J

    VBA to transpose and delete data

    Hello folks: I have recently been given a report and data layout is basically unusable. Here is the current output: <tbody> Last Name: Smith First Name: Jonathan Card Number: 1132 Employee Ref: 111222333 Last Name: Brown First Name: John Card Number: 2233 Employee...
  19. K

    Find record, copy info from specific cell on one workbook and paste into a different cell in 2nd workbook

    Hi all I have lurked on here for a while and found it a great help in my travels. I hope you can help me on my first post ! I have two workbooks. "END" which contains a large record per row, I press a button on this and it send a condensed version to a separate workbook "MIDDLE". The user...
  20. P

    Copy and Paste rows but changing one of the values

    Hey there! I'm pretty new to VBA so right now I am very confused. I have a spreadsheet with a lot of information for individuals with a lot of columns but the ones i care about are: Name, Surname, Company, and Property Address. What I have to do is use a macro(button) to move them to another...

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 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
Top