copied

I have a script that currently copies the “Active Cell” which will always be between K123:K149 depending on which one is active. These cells hold the users first name which is copied into the last row of Column “C”. What I need to do is copy the cell to the right of K123 (L123) at the same time...

Hi, I am looking for a script that takes an InputBox entry then compares it with the last two characters in cells in column C. When the match is found, I want the data copied to another sheet. say from Sheet1 to Sheet3. The data table starts from B1 to H100 Thanks In advance Kelly

hello, I have a a file which has info such as qty and description of items in the same column. I need to separate the info into two different columns or at minimum copy just the starting numbers to a separate column. The info is usually in this format with the info needing to be extracted or...

Hello Everyone, My macro is basic and all its doing is copying (specific range) and pasting that range in another file. Because there is a lot of data to copy and from many different files. It is difficult to keep track of what is copied and what is still missing. I would like to have some...

I copied a column of data and pasted it in another column, the letters are now red instead of black and it wont let me fix it. Does anyone know what is going on here!?

HI! I am using a vlookup/match to populate fields from column headers. For the most part it's doing exactly what I need except instead of pulling column 2 twice and not pulling column 7. code I am using: =VLOOKUP($A$10,$A$2:$G$6,MATCH(B9,A1:G1,0)0) I copied the code across the columns it...

Hello all, I use excel version 2007. I have a excel file consisted of 300 sheets. How can I write a macro by which rows 1:100 and columns A:K from each sheet to be copied in a new sheet after each other, that means in the new sheet rows 1:100 are copied from rows 1:100 of sheet 1, rows 101:200...

I need to create a sheet whereby a copied section repeats a variable number of times. The below is what i have come up with. It is written to find the first empty row in the sheet paste in the copied selection. Then repeat as many times as per the number in cell AH2. Right now my macro is...

Hi My formulas, especially the more complex ones, works in my Excel 2010 at home but gives an error message in 2016 at work!? Even when copied and pasted from 2010 to 2016. Annoying! Any help will be much appreciated.

Hi All, I have created the below macro using macro recorder, and need some help to loop the task until now more links in column C. Task: Open up a workbook via a hyperlink in column "C" on a master file, in the newly opened workbook copy a row of data in a hidden sheet and paste this data into...

How to paste copied data after the existing data

Sometimes when I try to copy a formula to a cell in a particular column, the formula does not get copied, just the result of executing the formula. However, when I copy the same formula to any other column, the formula is indeed copied. Explanations and proposed solutions are welcomed.

Hi all, I hope you can help me. I am trying to filter by a name "Tree" in column "E", and add the values in columns of columns "B", "D", "G" in another spreadsheet ("Sheet5"). My code is shown below, which it does the filtering but it pastes Columns A to F and I would like to paste only columns...

Hi There, I have the following code pasted below attached to a button: This is really annoying me because the code works if the worksheet is unprotected BEFORE running the macro. However if the worksheet is protected the code produces the following error '1004' Paste special method of range...

Hi can conditional formatting be copied? Thank you.

This is an odd situation. I know how to fix this without a formula, but for my purposes I need the data to be copied from one cell to another cell using a formula without amending the cells manually in any way. The problem is that the original cell is not recognizing the date as a date so the...

Looking to copy 6 columns which are not adjacent to each other, if cell value = a specific criteria to another Workbook starting in Column K. The column row height could change when received. The order on the copied "Master" sheet is - Column B - Column C - Column I -...

I wanted to use the same layout for two projects, and was to lazy to create an entire new worksheet, so I made a copied of the worksheet's whose format and VBA codes I wanted to use. Apart from the colour scheme, I've made no changes to the copied document. The VBA code still works in the...

Hi all, I'm new in this website and just registered. I have got one question and would like your help. How to prevent duplicates data to be copied in a range ? On other words, how to tell Macro not to copy data that already there in the range? Best regards.

I'm a bit suck on this one, In need some help please to work this one out. I need to copy ALL DATA on sheet2 Range A-M and paste it in next blank row on sheet1 column B so all the copied data will sit in columns B to N And I need Todays date going into column A for each row that has been...