copy and paste

  1. 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...
  2. 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...
  3. 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...
  4. 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...?
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. E

    Data Sectioning to Report Template

    I have two sheets in my workbook---I'm looking to scan the data in Sheet 1 and place it into specific sections (set end destination in Sheet 2). I'm looking to take all of the rows in Sheet 1 that fall under a certain criteria and paste them into their respective section in sheet 2. "If the...
  10. B

    VBA Copy Paste

    I really need some assistance if someone could help...likely really easy for you guys. I have been searching for examples I could use for 2 days... I am trying to use VBA to copy data from multiple worksheets within a workbook to a worksheet called "Data" within the workbook. - copy multiple...
  11. N

    Copy data from specific named worksheets and combine on a single worksheet

    Hello all. First post/attempts at this VBA. I have had no luck copying and pasting every code I could find... either they copy data from every page, have errors, or require some toolkit. I'm trying to combine all data from two different sheets XPO, and DDD into one sheet CDR. I'm also...
  12. M

    Pull data from multiple workbooks to populate new workbook

    Hi, I want to create a spreadsheet that will pull data from a form that my clients use. There will be many of these forms and each one will have a slightly different file name but be stored in the same folder (C:\Users\MWa\Desktop\VBA Test\filename) I want to copy the exact same cells from...
  13. D

    copy tables, then transpose and paste into other sheet.

    hi everyone, I'm not the best in marcos and I've been searching for a solution to this for a while. So what I'm doing is copying a table in a worksheet into another worksheet and transposing it. Some worksheets that contain the original tables can have a lot of tables which is way a marco...
  14. R

    Number Data Does Not Copy Correctly

    I have my data on Google Sheets, and I need it on MS Excel. Here is what I have tried. Copy and paste (multiple formats like number, plain text, HTML). I also copied and pasted it into an email and onto notepad. I also directly downloaded the file from Google Docs as an XLSX format, and that...
  15. S

    Please help me with this error of #ref

    Hi guys Please can you help me with this code. I have 2 workbook namely sub.xlsx and overall.xlsx. after I click on the button named update, col e72 to e110 should be copied to overall.xlsx but i do not know why the data pasted in overall.xlxs are all #ref. Why? Cell e72 to e110 are in a...
  16. S

    VBA Code to copy data from one workbook to another

    Ok, so this is my dilema, I am trying to set up a template that can copy data from a sheet in one workbook and paste it in to another. So why am I failing. The code is below. The first part opens the workbook that is designated in cell B3. Next I need to copy the data from that workbook on...
  17. S

    VBA Copy Paste Multiple Sheet to one Master Sheet

    Hello Everyone, I would like to ask an assistance, I am new in scripting VBA and I need help on how I can transfer all the data from multiple sheets to one Master sheet in the Excel File. I have 6 Sheets where I'll get the data and the data are in Range A7:K16 (this range applies to all the...
  18. F

    Copy & Paste a range n times (n in a cell)

    Hi, I've recorded the macro below. a) It selects rows 1:52, copies and pastes on the cell A53 (so immediately below the last row that is empty) b) Selects rows 53:104 copies and pastes on the cell A105 (same number of rows - 52 - starting from the cell immediately below the last row c) in the...
  19. J

    Copy from Excel Paste as Formatted Text in New Word Document

    I am attempting to export my data from excel into word, but I need to paste it as formatted text (rtf). Does anyone know how to do this? I would also like to change the orientation to landscape, and set the margins to .75 on all sides. Any thoughts?? Sub printer() Const...
  20. K

    VBA - merged cell query

    Hi all, Is it possible to Copy a cell value and paste that same cell value when the original cell is merged without the excess empty cells? The merged cell is 4 cells horizontally so when the macro runs, it copy and pastes the value of 1 cell value and 3 empty cells Thanks

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top