cop/past

Hello I'm moving completed tasks from one sheet to another and want to be able to move a task back into my worklist sheet. I have a vba code in Excel for cutting and pasting rows from one sheet to another based on cell value="completed". Now I want to be able to reverse fromthe completed...

Dear best regards I am trying to get the values that are located in column B, to be reproduced in column C in the same order as they appear. The problem is that I have entered some formulas that do not allow me to obtain the values I require, and instead they always reproduce the same one...

Hello! I have a problem, I am completely green in programming and I need to write vba code which will copy data from one sheet to another. The problem, however, is that I have to copy the second column with a maximum of 17 tables (the number of tables and rows in the table varies depending on...

Hello Friends, I am trying to copy a range of data into a new sheet, but every single cell in this range need to repeat for four time. For example: (I have over 1000 cells in the original data) The VBA code that I created loop through the original data selection, but couldn't copy to the...

I currently have 3 sheets: Data1, Referencia1, and Summary I am trying to get the column that's in column 1 and 2 of the sheet Referencia1, store it in a variable and use it to copy paste the columns in the order that is specified in columns 1 and 2. In column A of Referencia1 sheet, I have the...

Hi all, I'm new to the VBA side of Excel and I'm trying to accomplish a statistics page where each day I can run the macro and it will look at a different worksheet and pull various values and paste them in into the relevant cell. For example, I have Sheet A cell D4 with a value of 120, cell...

Hi guys, My name is Tim and I am new to this Forum. I experience a lot of trouble while designing my first code in Excel VBA. The problem is as following: in column B(worksheet 1), I inserted the names of some students. in column C, I inserted the marks of the corresponding students (see table...

I know the Running ants show up when Copying and Past….. But is it Possible to get them to show with out doing the Cop/past function when a value is set en a Cell Hjemmet