entire

I use excel 2010 for a work order worksheet. One the work order is complete ( the work complete in say J3) I want to move that entire line to worksheet 1 (from work orders). So if J3 says "complete" then move entire line to worksheet 1. Please help. Thank you, Justine

Can somebody help a bit please, I have cobbled together the below code to allow the user to insert extra rows. But I have a couple of problems. 1. I need be able to force the user to select the entire row, because at the moment if they select a cell not the row, the code just inserts a copy the...

Hi all, i would like to use VBA code so that to delete entire row if met two criteria. Col."H" is 0 (zero) and col. "N" is blank. Thank you all in advance

Hi All: I am trying to write a formula to reference cell A1 in this workbook. I am using the entire filepath in hopes of being able to access the data without the other workbook being open. C:\Users\Username\Documents\Report\[Test Workbook.xlsx]Sheet1 Any suggestions?

Delete entire row if cell in column C contains multiple criteria.

What is the vba to make an entire row not bold?

hi, I have a worksheet where I need to delete data in column A by selecting Ctl+spacebar buttons in keyboard and delete button to clear entire data EXCEPT header in cell "A1".. how can I do that.. please help:warning:

Hi I am looking for a similar to the below formula to find the count of item in each and every row in the entire column. =COUNTIF($A$1:A2,A2) =COUNTIF(Table1[[#Headers],[ColA]:[ColA]]:[@ColA],[@ColA])

Hi, I am currently using excel 2016 and I am trying to create a formula that can look up a specific table name and return the entire data table, but I am not sure how I would go about doing this. I have tried using the lookup functions but that wont return the entire table. If anyone has any...

Hi all, i would like to prepare a VBA code so that to run through col. "F" and where the text is like "Opening Balance" and in col. "J" is zero number "0" should delete entire row. Please see below an extract of my data row "28" which i wanted to delete. Thank you all in advance...

Hello everybody. I have 500k rows to check. If cell "H" is not beginning for "CODE", then delete entire row. How You can imagine, with a such amount of rows the process takes too long. How can I speed up? May be with a REGEX strategy? Sub deleterows() Dim rw As Long With...

I have a worksheet where I have applied conditional formatting to color every other row. Sheets("Dealer").Select With Range("A1").CurrentRegion .FormatConditions.Add Type:=xlExpression, Formula1:="=MOD(ROW(),2)=1" .FormatConditions(1).Interior.ColorIndex = 15 End With But for some reason...

Hi Everyone, I am looking for ideas getting an HTML document into Excel. I've tried the standard "Get Data" but I end up with a 4MB file and have 30-35 tables daily. If its possible to import the entire HTML document to one worksheet with a one click solution that would be great. Any...

I need some code to see if an entire row has been selected within a range and also I need code to see if an entire row has been selected within a table, tblCosting. Thanks, Dave

Hi All, When I use a direct hyperlink the used VBA code in my file work to highlight the entire row in the target file. However if I use dynamic hyperlink VBA not working. Please suggest.

I have a workbook with multiple worksheets. I was working in it a week ago and everything was fine. I opened it today and the entire workbook, including all of the menus, is grayed out. Where the cells would be is just a big gray blank, no borders, no cells, no numbers. Even in the File menu...

Good Day Mr. Excel users, I saw my colleagues doing this weird formula that I never seen. =VLOOKUP(E:E,reference!I:L,4,0) above lookup value refers to entire column E:E but assuming above formula in in row 2, it only uses E2 as reference and it works. Can someone please explain to me on why...

Hi all, i would like to use VBA code so that to delete entire row, where in column "A" is number. Due to headings the code should run from "A4" and rows down. Thank you all in advance

I want to have what value is entered in column E which is Yes, No, or Blank to dictate what is in column F to list Yes = HI, No = N/A, Blank = Blank. I figured out how to do if for a single cell but how do you apply it for the entire column E and R? Sub Network() If Range("E3").Value = "No"...

Hello,</SPAN></SPAN> I want a code that can select or deselect offset entire column double clicking on cell.</SPAN></SPAN> For example if I double click on any cell in the column "L", I want entire column "C" could be selected. If I redo double click then entire column deselected</SPAN></SPAN>...