copy paste

  1. P

    Next Level Gantt Chart - Trying to Copy Certain Data

    I have a spreadsheet with four sheets: 'Full Project', '1', '2', '3'. On each is a Gantt Chart with activity table, the full project sheet has the data for the full project, sheets 1-3 contain the same data for only selected periods of time (each third of the project timescale effectively). The...
  2. 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...
  3. G

    Issue with copy worksheet code

    Hi All, I am using the below code to copy a worksheet to another worksheet. But, what I am trying to achieve is that the workbook pastes this data onto an existing worksheet. Below code creates a new sheet and pastes the contents within. The reason why I am using this code is because the source...
  4. C

    Copy Down Data Until end of range

    Hello, My goal is to be able to copy down data until the end of the range. The range can vary, based on the size of the raw data pasted. Running the following script works to copy down the data (not the prettiest, but it looks to work), however because it doesn't know when to end, it errors...
  5. Hrishi

    Transpose of data from horizontal to vertical

    Hello, I have huge data in one row. I want to create a column with same data and which will be linked to the original horizontal data so that whenever I change in horizontal data, column data will also change. e.g. <tbody> row 1 2 3 4 5 column 1 2 3 4...
  6. S

    code for changing sheet on double click???

    I need excel to switch to Sheet2 whenever I double click in column one. Also I'm new to this, I already have a macro running for the A column that already activates whenever a cell in column A is activated. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As...
  7. andrewb90

    Copy/paste in vba not keeping merged cells/color formatting

    Hello all, I'm sure this is a pretty simple thing. I have a code that is copying visible cells to another sheet. However any merged cells that are within the range become unmerged and any font choices/color return to the default. I'm just not sure of the correct wording to put in the line...
  8. Q

    copy paste rows x times and change some data

    Hello guys, I want to make a template which creates the same x rows at once based on a given number. It also needs to change some tekst in the meanwhile so not everythingis just copy paste: Here is an example on how it should look like. Zippyshare.com - Book2.xlsxMy vba knowledge is limited...
  9. A

    copy paste to different file with changing name

    First I'll let you know what I have and then let you know what I'm trying to accomplish. I have a file - products.xlsm with a copy row macro that will copy from "XYZ worksheet" and paste to "Quote worksheet" This is all working fine and no issues. What I'm trying to accomplish is to be...
  10. I

    Disabling ScreenUpdating cause copy-paste to throw 1004 error.

    Little background to my question. (Office 2010, if it helps) I'm working on the project which should do pretty simple thing - take data from two sources and make printable pages (mean align data on the page properly, so it looks nice when printed). The problem is - both sets of data should be...
  11. gallen

    Copying gets cancelled in VBA

    I want to be able to double click a cell and have VBA to copy the row of information. I currently have: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)'code to copy the row of information to the clipboard Application.EnableEvents = False Dim s As...
  12. E

    Copy, Find Row, Then Paste Between Worksheets

    I collect orders through e-mailed Order Form Workbooks (file names will vary). When the order arrives, my macro unprotects the Order Form, unhides the Order Summary tab, copies the order data and activates the Order List tab in the Master Workbook, which is already open in the background and is...
  13. A

    Macro needed or a way to do this fast?

    Hi All memberz, I have around 2K records in a excel sheet with fields, Company, City, First name, Last name, Email, Then First name, Last Name, Email, Then First name Last name, Email, and so on.... Let me explain this. Each row contain a Company details and their workers first name, last...
  14. J

    Simple code changing required VBA macro excel to copy paste cells

    Sub Button3_Click() Range("B19", "B22").Copy Sheet4.Range("B" & Rows.Count).End(3)(2).PasteSpecial xlPasteValues Sheet4.Select Application.CutCopyMode = False End Sub I need only to copy the value of B19 and B22 on "Sheet4" B & C Cells respectively but when I use the above formula, it copies...
  15. L

    “Unable to get the VLookup property of the WorksheetFunction Class” error

    Hi all, I am trying to set the values in column B in my Workbook "Copy of Dash Board Shell" (shown in the image below) equal to the value derived from my HLOOKUP function from my data workbook shown as second image below Copy of Dash Board Shell Data file so esentially the code will find a...
  16. R

    Copy and paste command toggle.

    I am new to Macros and VBA but have quickly realized the potential and I am working on automating a task at work. I would like to use a command Toggle button to copy data from one sheet into the next sheet every 30 min. The first sheet" Import sheet" is updated every 30 min with new data. I...
  17. J

    VBA: Open Latest File in Folder and Copy between files

    I am looking to open the most recent file in a certain directory, copy certain ranges from that file into specific ranges of another file (the workbook from which I am executing the code) then close out the workbook which I had previously opened. I have the code to open the most recent workbook...
  18. T

    Copying a Concentrate into and Excel Cell

    So I have a cell that has the following formula, =CONCATENATE(G4,H4,I4,J4,K4,L4) This reads <tbody> ,IF("Butter"=$C$2,C45) Now I want to copy that and add it to a cell that already has a bunch of similar statements Currently it looks like this...
  19. L

    Copy paste data from 2 sheet to one sheet in same workbook

    Hi, I have a 3 sheeter excel, what I want is to copy fixed rows from one sheet named: Inv and copy next row each time I click the button from sheet: Details and paste values to specified cells in sheet: Reg. The code I have at present does that however it pastes the formula and not the values...
  20. C

    VBA Question

    Hello, I am looking for help with a scrip. A play off of the following script if possible that would copy the cell, instead of delete the row: Set SrchRng = ActiveSheet.Range("A1", ActiveSheet.Range("A5000").End(xlUp)) Do Set myCell = SrchRng.Find("Agent", LookIn:=xlValues) If Not myCell...

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