copied

I need a formula that will take a number from column A and divide that total starting number into equal values over a variable series of cells in the same row. Example column A1 = 100, and the formula is copied and pasted across 10 corresponding columns on row 1, the returned value would be...

When I format paint cells using Paint from a cell that has conditional formatting applied, the results seem to be fine, but the conditions for the copied cells don't change - see attached. In other words, the Condition value doesn't change, but it applies to the entire range I copied it to...

I am trying to copy and paste data in column A to the blank cells above it. For example: Cell A5 contains "1203" and I want it copied to the blank cells above A1:4 Cell A12 contains "1237" and I want it copied to the blank cells above A6:11 Cell A18...

Hi, I have a spreadsheet that in cell A1, has a percentage value that is constantly changing based on different data being inputted into the sheet. Is there a way for each time that a change log is registered in that cell, for the cell value to be copied into cell A4. Then the next time there...

Hi Everyone, I add my sales into sheet "Quotes" Range is D27:O51 The data for each sale is two rows, row1 the details, row2 Notes, (Not all sales have notes) so what I want is a macro that will copy the last "Row1" sales details and paste it below but it needs to place it 2 rows down to miss...

Hi all I have over 15 files need to combine data in sheet(G001).range(D11:D25). I want all data range transpose and combine into summary workbook at sheet(source) with conditions: 1. Column(Ai) is the filename copied, i from 2 2. Data copied from all file transpose from range(D11:D25)...

Hi All, I have spent quite some time searching for a solution to this problem without success so thought I would post my first post. I would like to make a macro that allows the user to input a cell value to determine the last cell in a range (A1:x). The range always starts at A1. Then the...

Hello everyone, I am looking for a marcro that can copy and paste cells. The value of cell X must be copied to a cell X + 6. So A1 text "Xteam" has to be copied to cell A7, this up to cell A380. The same applies to cell B2 + 6. How can I do this, I can not do it thank you in advance elmalle

Hi All I use a application called TheFolderSpy, this application simply watches a specific folder for any changes (new files created, files deleted, new folders etc). Folderspy then opens a excel file which has a bunch of code to run on open, working with files/folders within the watched...

Hi Everyone Probably about a month or 2 ago I was able to copy a few rows and insert them on my desired location multiple times. Does anyone know if this was just an update or a tick under some or another setting? The rows copies has formulas in them thus the clipboard would not work for this...

Have copied data. Want to insert the data in workbook Alpha in cell A1. However I want it to loop though each sheet and insert the data in the sheet named: TB*, meaning TB plus any other characters following.. If there is no sheet called TB*, I want a new sheet to be copied in called TB. And...

Adding this code allows users to click and drag: Private Sub Workbook_Deactivate() Application.CellDragAndDrop = True End Sub However, if I copied a cell in this workbook, hit Ctrl + N, then try to paste in another workbook, nothing gets pasted. How can I resolve this? Thanks

I have two tables. I want to copy data from one table to another table (Result) between the given time. So if I change the input time, only the values between these times should be copied for all columns. Can anyone help? link to workbook https://1drv.ms/x/s!ArYn8TW3_a3d4UHVl5k4SrTwQIAl

Hello, I copied over a worksheet from 1 workbook to a more comprehensive one. In this copied worksheet, I've tried to have some cells automatically calculate based on the other worksheets. For instance Cell A1=CustomerName, where CustomerName is a named cell elsewhere in the workbook. However...

I want to be able to pick up values in say 20 individual rows from 10 columns. The column to be used have a value of 1 or 0. The column to be used is the column with a 1. So where the column has a value of 1 then each of the 20 rows in that column have to be copied to another column. If the...

Hi can anyone help? I want to copy 14 rows of data from sheet2 "E:K" to sheet1 "T5:Z18" I have a start row value on sheet3 "Q2" and want the data being copied from sheet2 to start from the row based on the value in sheet3 "Q2" ie If the value on sheet3 "Q2" has 21 then the data to be copied...

<tbody> ROUTINE MAINTENANCE Bus No Job No Type ins VOR 12345 NE TYRE REPAIR Y Y 12345 NE TYRE REPAIR Y Y 12345 NE TYRE REPAIR Y Y 12345 NE TYRE REPAIR Y Y 12345 NE TYRE REPAIR Y Y 12345 NE TYRE REPAIR Y Y </tbody> If the above...

Take a look at the spreadsheet. The references will change after sorting and break the calculations. Absolute referencing is not an option. The table has to be copied periodically to another sheet and placed it at a different row (the columns are identical). Absolute referencing will break the...

I'm certain this question has been answered numerous times, but I haven't found an answer that fits my particular needs. I'm trying to copy several cells from 4 different sheets of a variable workbook named by date. It would be saved as "17-Aug-18" today for example. Then, I'd like to paste the...

I am trying to make sheet 1 a place to enter data and sheet 2 into a publishable sheet. All my code works until I try and insert the range I copied from sheet 1. I tested it and range is selected if I don't enter the, Selection.Insert Shift:=xlDown command. Once I put this part of visual...