copy & paste rows

Hello I am looking for VBA to copy the first row in a named range and paste it to whole of the named range. I am sure its very easy but I cant find anything. Thank you tttommy2

Hi All, I am having a lot of trouble with a particular spreadsheet I'm trying to develop. It's a project tracking tool and what I need to do is copy and past all the late projects into a specific sheet for review with our dept heads which is quite laborious. I am trying to find someway to copy...

I'm trying to create a macro to cut a row with multiple columns and paste it one row above. Next I copy values from this recently pasted row (columns A-G only) and paste it in a blank row which was created from the above action. This code works for only one row but I need to highlight different...

Hi, I am pretty sure that this should be a relatively straight forward macro, but I can't seem to work it out. I am trying to find data in a spreadsheet (data always in column H), once found copy the entire row and paste the row into a different tab. There are multiple rows within the...

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

So here is my issue. I have fumbled around multiple forums trying to find the answer. I am new to vba for excel and I have hacked together a macro from bits of code I found in these forums. It does what I need it to except for one caveat, the second part of the macro uses a set range but i...

I feel like this has or should have been asked a million times, but I can't find the answer. I'm searching a particular column of 10,000+ rows for a word. It finds all instances. I hit ctrl A, and all of those cells are selected... great. Now what can I do? I need to select the entire rows...

Dear Experts, I found a macro from your forum which copies the entire row based on a cell value ("y") -Courtesy Mr. jindon MrExcel MVP. If we type "y" in column D, the entire row is copied & pasted to sheet 2. The code is as follows. The only point for clarification is how will the code change...

I have data in multiple excel workbooks that I am building a macro to bring in to a single workbook. The data is a list of tenants and move-in dates etc. The data covers columns C:X and begins at row 9. The problem is I need the macro to determine how many rows are in the data set so I know how...

Hello to everybody! In an excel file with more than 40.000 rows (this might variate) and 50 columns, the code checks for specific strings in a specific area: going from the second row it checks from column C up to column G (or at least I think so), up to the last row (which is unknown because...

Hi Guys, I really need help trying to get a VBA macro to do a Vlookup on another sheet then to find all the rows with that value, then copy them and paste them on another sheet, hopefully this is possible and that someone can help cause I don't have any knowledge on VBA. Ok so I have 2 sheets...

I am trying to write a macro that once the warehouse guy is done for the day can create a new sheet titled 'the current date' totals, then export all rows that have x in column A from a sheet called 'the current date' to this new sheet. I have the template done for him and a macro that creates...

Hi Team, Looking to know if there is an easier way to copy down a formula through 100K+ of rows without causing excel to give up and die quietly. For example I am using this formula =IF(COUNTIF($Q$2:$170621,Q170621)>1,"Y","N") Any help will be greatly appreciated as I have a bit doing this...

Hello All, I am in search of a greater being who possesses the power to help me with my macro. I will tell you what it needs to do and what I have come up with so far. 1.Based on Sheet "Main" Cell "B23" which is a drop down list of File names that correspond to Company names. 2.Based on...

Hi, I'm having trouble coming up with a way to create a code in VBA that would parse through a table of data, recognize if a value was in between a set of numbers and if it was, copy and paste the row into the next avaiable empty row in the new sheet. Then, if all went well, it would go down to...

Hi, I'm having trouble coming up with a way to create a code in VBA that would parse through a table of data, recognize if a value was in between a set of numbers and if it was, copy and paste the row into the next avaiable empty row in the new sheet. Then, if all went well, it would go down to...

Hello, I have a situation that I have 30 tab in a file and want to copy specific location from all tabs (excluding 5 tabs that I described) and past into specific location in "IMPORT" tab one after another row. Note: It should be coded such a way that any future creation of tab with the...

i get in my work sheet prices updated from exchange in row 2 every minutes for 30 cells i.e.from cell A2 to Z2 i want to copy value of this row copied every 15 minutes in same worksheet from row 3 onwards( or new rows ) for study of rate changes every minutes i use excel 2007 thank you for...

Hi guys, I recorded a macro but I am unable to take it to the next level and automatize the same procedure until the row ends. I am sure this is an easy problem for most of you: Range("B2").Select Range("B2:B49").Select Selection.Copy Range("D2").Select ActiveSheet.Paste...

Hi, I have spreadsheet of data, I need to extract any rows that have blanks cells in columns F or P or T. If possilbe I would like a macro I could run that would cut all of the rows that meet the above criteria and paste them in to a seperate sheet. Any help is much appreciated, please...