copy paste

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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