copy and past cells

Hi there, I have created a simple macro to look to copy some data from one sheet to another however I have just noticed that the source data can actually fluctuate as to where it may be so my cell reference of going to AL9 and copy the data in AL9-AL500 is not ideal. The header in AL9 (or...

Hello community? I am trying to copy two not adjacents colums (A and E) into a new sheet by using a VBA code. These two columns contain some data until row 45 (assumption), I just wanna copy the data until the last occupied row and not the graphs and calculation that might be below. Since the...

Ok so in short I am very new to this, and have been doing OK until this stupid roadblock. I have a bunch of ID numbers in column A of sheet one. when I double click one, I need the value in that cell when double clicked to be copied into cell b5 in sheet2 and the focus of the screen change from...

I would like to copy the active row and paste it right below (in the same worksheet) with columns "D" through "P" being null or just copy columns (A,B,C and the rest blank, but this is a table. I tried with my vba but i get an error that I can not do it in a table, but I see others doing it...

Hi I am a vba newb. What I tried to do is copying the data from one cell to another. Sub DataManipulate() Row = 13 ' Do Range(Cells(Row, 4), Selection.End(xlToRight)).Select Selection.Cut...

Is there a way to have a macro copy information from a seperate weekly data file into my main workbook when the file name changes every week? The main part of the excel data file name remains the same, but is updated with the week at the end of the file (i.e. last week: "Weekly Data 3-30-2012"...

Hi all Wondering if someone can help. I've a workbook with a couple of worksheets in it, where one worksheet has a column of data where I want to link the data into a row on another worksheet, however I'm having challenges and really can't work it out. I can drag the formula as it just copies...

Hello there, If some could please help with a simple macro. I have workbook contains of several sheets. I want to copy and paste form one sheet to the other. Based if one column have no value or not, I want to bring that value to the other sheet and other data form the same row as well and past...