select row

Hello all, I'm trying to populate an order form ("Supply Usage Form") using VBA. I have a command button that, when selected, loops through a location-based inventory sheet ("Location") and checks columns L & M for missing or expiring items. If any are found, it auto-populates the order form...

<colgroup><col><col span="2"></colgroup><tbody> Product Cr1 Cr2 A 0.9619 2.54 B 0.8791 1190.17 C 0.8386 1567.58 D 0.7724 1.36 E 0.7508 1.53 F 0.7508 18.06 G 0.7485 1659.38 H 0.7485 1649.66 I 0.7485 1661.76 J 0.7153 1617.04 </tbody> My Excel has 3 columns, these...

Hi All: In the below example, I am trying to look for populated values in Column A (range is A2:A5). If there are, (i.e. this would apply to A2 and A5) then copy/paste the corresponding row value from Col B into Col C. Initially, I tried to use =IF(A2>0, B2, ""). This worked, however I have...

I can create, copy / paste and save a text file to a specific directory (e.g. All of my data is on the 2nd row...so all of the data will be taken from H2, M2, R2, etc...) How can I make the row that contains my data variable or be able to select a different row of data? It could be one row at...

Goal is to delete all rows from row 2 to the row of current selected cell. For example if I have select a cell in row 230 selected I want to delete rows("2:230"). I tried ActiveSheet.Rows("2:" & row_number).Delete. But this give me a Run-time error '13': Type mismatch. Any help would be...

What I want is for the value of the active cell to determine the number of rows deleted - and then delete all duplicates. Here's my code: Sub test() ' ' test Macro ' ' Dim iRemove As Integer iRemove = ActiveCell.Value - "1" ActiveCell.Offset(1, 0).Rows("1:iRemove").EntireRow.Select...

Hello, I'm looking for a macro that will select the rows in column U that have a corresponding value in column A. Column A has contigous cells with values whereas some of the cells in column U are blank and some have values. Thanks

HELP! I have a huge spreadsheet that i need to select a bunch of rows. the rows i need to highlight are contingent on data in a single cell in column AA. How do I do this? Once I highlight the rows, I would like to copy and paste in another sheet and maintain the blank rows that were not...

Hello mrexcel users, Can anyone help me? :) I need 2 macro codes wich can do the following (one is for a search button, the other one for a modify button): If I input a value in the left box of the search frame, I want it to look for the value in the range B8:B1008 and if I input a value in...