row

Hi. I've got a list of names in Col G from row 14 down. Users add the name or names of the owner/s of the associated task described on that row. VBA allows the user to enter more than one name in the cell as sometimes two people are involved on a single task. What I'd like is to have a...

I have the below code copying data from multiple worksheets on to a master worksheet without the header row. It works fine if data is entered however if no data is entered on a sheet it copies the header row. How can I change it so that the header row is always ignored even if it is the only...

Hi All, Need some code to do the following. For a range of rows from Row 10 to 50000 Hide any row where COL A has a value = 0 Many thanks....sorry for such a numpty question. James

Hello! I am yet to figure out how the following works, but use it all of the time to find the last used cell in a column and offset 1 row: .Range("B" & Rows.Count).End(xlUp).Offset(1, 0) = Cel.Value I am trying to apply the same logic to the following: Cel2.Offset(0, 5).Value =...

Hi I need a formula that will copy the data is the first row of AFGIJKLMNOPQR down the sheet, as far down as long as there is data in column C? Can you help?

Hi folks I have an Excel Table with names and abbreviations of names (two columns only). I would like to prevent users from deleting the header row and last row in the table. <tbody> Abbreviation Surname and Initial PM Masters, P JL Leonard, J JM Matsau, J TOTAL 3 [given by...

I have this code: Range("A" & Rows.Count).End(xlUp).EntireRow.Copy Range("A" & Rows.Count).End(xlUp).Offset(1).EntireRow.PasteSpecial It copies the entire last row that contains data and pastes it one row below. I only want it to copy part of the row, columns A to I to be exact. How do I edit...

Dear MrExcel, I need to insert rows based on certain numbers and I need your kind help and assistant to help me out. I have 2 columns, A & B A is containing value (string) B is containing value (number) If the value in column B = 1 then no inserting rows But if the value in column B <> 1...

Hi Could you please help me to fix the below formula in column and its drop down (by increase cell count) till the last row in the VBA Macro =IF(C2<2,"0-1 Days",IF(C2<3,"1-2 Days",IF(C2<4,"2-3 Days",IF(C2<6,"3-5 Days",">5 Days")))) at the drop downing Column C has to increase...

Hello I'm looking for a macro that will copy cell contents of column E into Previous Row as it shows in this excel sheet in my google drive sheet. " From bottom Up check for column E if it find blank cell then copy that row into above row. E.g in this sheet in column E cell e15 is blank so the...

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> I need a VBA, which can highlight 1 character out of 1X2 in the each row so far each time 14 total are selected within the 14</SPAN></SPAN> Example...

Hey, Currently this pulls the data in one row Ary = Application.Index(wb2.Sheets(4).Range("A8:U17").Value, Evaluate("row(1:10)"), Array(1, 3, 4, 7, 13, 14, 15, 16, 17, 18, 19, 20, 21)) Ws.Range("A" & L).Resize(10).Value = wb2.Sheets(4).Range("D3").Value Ws.Range("B" & L).Resize(10).Value =...

Hi i would like a vba that does the flowing if my seventh character from my sheet name begins with a "4" then delete row 12 from the sheet if not continue to the rest of the code Thanks

Hello all, Bit of an amateur trying to learn more on the use of Macros. Hoping for some assistance with this issue: I want to be able to search through my data to find rows where Column D displays "Negative".If it doesn't display "Negative", just move on to the next row. If it does display...

Hi Everyone, Ok so a bit of a strange one i'm doing a Billing cycle that shows how much is owed but i need to be able to adjust the amounts and could do with a macro to help. So I have three ranges we take to take into account. AC10:AC26 is my indicator for what we are goig to change. Z10:Z26...

Hello Friends, Is there a way to move the selection to the second column of that same row. Like if the selection (target cell) is lets say column H32 then I would want the code to make the selection to B32 or if the selection (target cell) in on A15 then i would want the code to make the...

Hi I have done lots of Google searches and found nothing on this. Normally I can find an answer on Google, or force the code to do what I want by trying a different method. I have a VBA problem that is driving me nuts. I'm using End(xlUp) to find my last row. When I hover over Last row...

Greetings, I have a Workbook for tracking change orders. When an ECO is closed, I select any cell in the row and run the following to erase the data and clear the formatting on that row. Sub Clear_ECO() MSG1 = MsgBox("This action cannot be undone!" & vbCrLf & vbCrLf & "Selected Row is: " &...

I am currently picking cells from another spreadsheet (MasterSheet) which is a flat row by row data set Column A to F 600+ rows. The Slave sheet I am using to create a more user friendly layout of the Master Sheet so same data but with a slightly different layout, with headers created from date...