copypaste

  1. A

    Copy Paste User Selection from Form to Excel.

    Hello guys, I have a form where it will display the random questions from "Questions" Sheet to the User. User will Select the Answer in the Form. I Need to Save all those Random Questions (as of now its 10) and Answer which User attend, Save it in "Answer" Sheet. Can you please Help on this...
  2. I

    Copy rows in seperate worksheets to new worksheet based on date

    Hi, I've got a spreadsheet with 21 active worksheets. 1 of those is a home page and the other 20 all have data on regarding deliveries for my company. I want to make it so that Excel automatically searches for any deliveries >=TODAY on all the worksheets and copies those rows onto a new sheet...
  3. R

    Paste Value from List into Separate Sheets

    I need some help - google hasn't led me to anything useful :( In my workbook, Sheet1 is a template used to analyze some data. Sheet2 is a list of values. My current macro asks a user how many times they need the template copied, and then copies Sheet1 as a new tab at the end of the workbook the...
  4. F

    Paste chart to the first sheet with specific name beginning with ....

    Hi, Is it possible to write a code line that pastes a picture from worksheet A to worksheet B, whose name starts with "Sheet.....". I have multiple sheets named "Sheet1", "Sheet2", "Sheet3" etc. and I only want to copy&paste one picture to the first sheet that comes up first. and I can't use...
  5. F

    Copy Paste Data From Outlook Email To Excel

    Hi All, I am trying to get data from emails in a folder in Inbox in Outlook 2016 in Excel. I found several codes that can do it but the thing is i do not get data in organized way like I want. But I noticed that if i open an email and then copy paste the body in outlook without its formation it...
  6. C

    Copy range of data from multiple worksheets based on numerical criteria

    I have been playing with this code for a few days now. :mad: I have a spreadsheet that has about 10 tabs. Only 4 of the tabs I need to use for this code. I created a master sheet called "Quickbooks" to make uploading materials into QB easier for the team and save hours a week for the...
  7. D

    how to select rows depending on a cell value using VBA

    I am trying to copy and paste rows from one sheet (fill) of the workbook to another (BD). The rows I need to copy depend on the value of a cell. If such cell =3, I need 3 rows to be copied. If the cell =4 I need 4 rows copied to the other. Is there a way of doing this with VBA?
  8. H

    Using vlookup to copypaste values to row using vba codes

    Hey Masters, Good morning! Im a newbies in VBA and want to learn more about it to speed up my work. I have this file which needs to be sorted everyday. Copy all the movements to each corresponding sites. Please see below the example. <colgroup><col><col><col span="4"><col><col...
  9. V

    Coping and Pasting with VBA on Active Cell

    Hi everyone, I am trying to copy and paste the value from B57 on the active cell using the code below, but right now it's pasting on D4. Is there a way to change D4 to be the active cell instead? Thanks in advance for the help! Sub copypaste() ' ' copypaste Macro ' ' Keyboard Shortcut...
  10. S

    VBA - copy rows that contain todays date in a column and paste to another worksheets next blank row

    Afternoon all, Huge thanks in advance for anyone who helps. My VBA knowledge is basic to none so please don't feel like you're patronising me by spoon feeding how I need to do this. I need to copy all rows that contain todays date in column V and paste them into another worksheet without...
  11. UNIC0RN

    Hyperlink to find data form another Woorkbook and copypaste data back to activesheet

    Hi All, I have 1 Workbook Template (Worksheet Master) which have hyperlink to another workbooks based on value choosed from dropdown list and will link it to Worksheet Membership (each workbooks have worksheet called 'Membership') by using command button. My question is, by using VBA: How can...
  12. S

    Copy sheet with cube formulas to new book results in #NAME?

    Hi! all my previous question I found answers on on this forum, but on the following question I couldn't find any related topics: I'm trying to write a VBA code to copy paste 2 sheets of my workbook to a new book. So far no problem with VBA code below: Sub Button1_Click() With ThisWorkbook...
  13. P

    VBA Copy & Paste values based on adjacent cell

    Hi all, Any help would be greatly appreciated. I have a spreadsheet I use to document tasks, I use column B to give each task (row) a numeric number which only appears should I have a task heading entered in the adjacent column C row. I use as if formula in column B. Ideally I would like to...
  14. C

    Macro copy first value from multiple header rows to new sheet based on header

    Hi, ive got a complication with pulling certain data based on header columns, my Data sample set looks like below. <colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody> header1 header2 header3 header4 1 6 5 6 2 5 54 5...
  15. O

    VBA: Copying Formulas and Array Formulas at the same time

    Hi, I am struggling with the following code, that in essence is trying to copy a range of formulas from one sheet to another: Sub CopySheetToSheet() Dim r, c As Integer Dim rngA As Variant 'HC Reference to Sheet5 Range Alpha Set rngA = Sheet5.Range("Alpha") r = rngA.Rows.Count c =...
  16. V

    HELP needed - VBA

    Can anyone help to fix this VBA? i am trying to have the formula below from cell X3 until the last row which have the data for the row.:eeek: Range("X3").Select LastRow = Range("X3:X" & .Rows.Count).Formula = _ "=VLOOKUP(RC[-22],'User Data File Backup Old.csv'!C2:C23,22,0)"
  17. F

    VBA Copy and Paste Cell Value Only- It keep returning #N/A

    I am having problems with the code listed below. I'm trying to use indexmatch with another workbook to get the values and save the value as cell values . But it returns a value of #N/A. I want a to save it as paste cell value only and not formula :mad: Can anyone suggest a solution? or...
  18. B

    Macro for copying data from First sheet to all the other sheets

    Hello Experts, I want to copy a range (a1:d6) from Sheet1 (Name changes everytime) to to the same cells (a1:d6) of all other sheets in the workbook (the number of sheets changes everytime). Thanks in advance.:)
  19. missfionaelizabeth

    Macro to copy row from one area of sheet to another

    Hello! Long time lurker, and I've always been able to find my answers here. But try as I might, I just can't solve this one!!! Basically, I have a sheet in which I need to enter learner details for learners booking onto a course. The sheet doubles as the signing in sheet (so the list can just...
  20. J

    Inserting Rows with For Loops

    I'm writing code to copy rows and then insert copies of the same rows below. The numer of times it should copy and paste those rows is defined as Unit 1-7. After each for loop, I would like the code to insert a different row that sepeates each block. Please see the code below. The bold italic...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top