copy&paste

  1. T

    VBA Code is not copying and pasting properly?

    Hi All, I'm working on creating an attendance spreadsheet between 3 spreadsheets, a 'marker,' a 'database,' and a 'record keeper.' In the marking worksheet I have the following code which will record and create a unique ID for each attendance marked which will be stored in the Database. Sub...
  2. R

    VBA code to copy range in multiple workbook, paste to master workbook contain sheets according to range value copied

    Hi. Appreciate any help. Need a VBA code to copy paste sheet.range value FROM multiple workbooks (same table format in each sheet) located in same folder TO multiple worksheets in a master workbook. These worksheets in the master workbook are named with same name as the variable in the copy...
  3. R

    VBA Macro copy cells or range in different workbooks same worksheet name to a single master workbook with date in every row

    Hi. I'm new to this Forum. Any help is much appreciated. The objective as per the snapshot where I need to copy & paste only for colored cells. I guess the only difference from the other posts is how to add the dates repeatedly in the Mastersheet. Need some sort of looping I guess. Appreciate...
  4. K

    VBA code to loop through user-defined directory and copy data from a range of cells in each workbook to a master workbook

    Hi! I am new to VBA and I have a folder with approximately 130 xls files, all with unique workbook names and worksheet names. I would like to create VBA code that allows the user to select the directory folder of the files to copy data from the range C2:J2 from the first worksheet in each of...
  5. W

    VBA help to match column header from different workbooks

    Hi all, I am looking for some VBA code to help me with the problems, it would be great if one can help. I have 2 workbooks, and there are multiple worksheets in each of these workbooks. In workbook2(sheetname1) I would like to find the column in workbook1(sheetname2) that has the corresponding...
  6. A

    Limit (Not total Denial) Pasting within a Worksheet

    Hello, I would like to deny pasting into certain columns (F:G) without disrupting that ability elsewhere. I've searched for this and have come close to a solution, but they haven't been quite right. I used the following but it restricts pasting for the entire sheet Private Sub...
  7. K

    copy and paste heading

    I want to copy the heading and paste it to another sheets with numarical order. that is the heading is worke id 1053 (sheet 01). and i want it copy from 1st page and paste it to sheet 01, sheet 03 ..... at the same time the heading also change with sheet name that sheet 01, sheet 02, sheet...
  8. K

    VBA - Copy/paste multiple rows/columns based on cells with conditional formatting

    I'll try to keep this short, but am a newbie to more complicated VBA. Would love some help and explanation of the logic on creating a macro which does 2 things 1. Looks at a range of data and highlights both the row and the column where a cell has conditional formatting. Note: The range of...
  9. L

    VBA Loop with multiple conditions on one sheet

    Not sure if this is a duplicate question but couldn't seem to find it anywhere. I have the following sample data: <tbody> A B C D E F G H I 1 EMPLID NAME Dept LOC JOB TITLE EE STS EFFDT HIST EFFDT HIST EE STS 2 123 Doo, Scooby 564 564C Driver L 4/28/2018 3/20/2017 L 3 123 Doo, Scooby...
  10. Q

    Excel VBA reuseable copy and paste below last cell

    Hi, complete beginner with excel VBA here. I have a list of people and their information on columns "A:D". Column "A" consists of the persons first name, "B" consists of their last name, "C" consists of their gender, and "D" consists of their rank. The list starts from "A10" and continues down...
  11. N

    Rates per city per KG

    Hello friends, I am new here but i need your help for a excel sheet that i am making. I have the City and the Weight in one sheet. In the other sheet, theres the cities, all weights and the costs. In the first sheet, we can select the City and the weight. I want to show in that same sheet the...
  12. A

    Making employee roster help please

    Hi Im a new user and im trying to make a roster sheet and really need some help any help is absolutely appreciated. I have some good formulas already set on 2 separate sheets that calculate the amount of people toward the manager ID and subtract in another column by total of unexcused from the...
  13. S

    Copying data between worksheets with ActiveX controls

    Hey everyone, I'm new to VBA and currently working on a project which requires me to regularly copy paste the same range of cells between different sheets. I have a CommandButton which currently executes the following: Sheets("04").Range("A2:B2").Copy Destination:=Sheets("05").Range("A2")...
  14. S

    Automatically copy& paste special (value)

    Need help on vb script to automatically copy & paste the value from a calculated field into a new field. Cell C5 is a calculated field, formula is (=SUM($E$9:$E$60)/C1) This field is calculating % complete. Cell C6 is also a calculated field, formula is...
  15. T

    Copy & paste data based on specific dates to another worksheet

    I've searched for nearly four days for a starting point to help with this project I have. Many simliar macros have been shared but I am just learning about marcros, so trying to figure out how to write it correctly is beyond me. Project: Take a list of inventory with inspection dates and...

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