Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need assistance with Excel 2007
Hello everyone.
Ok, here is my issue. I have seven sheets each with a table that is from B14 to U513. In column Q (from row 14 to 513), of each sheet, there is nothing (" ") or a number from 0 and up. Here is what I need. On sheet 1, for each cell in column Q, if the value is null (nothing), move to the next cell. If value is greater then 0, I want to copy the corresponding row onto sheet8. Once sheet 1 is done, i want to do the same operation on the next sheet, then the next, until all 7 sheets are done. Please note that although I am pretty good with formulas, I know nothing about programming macros or VB. But i have a feeling this would be a piece of cake for some pros on here. Let me know if you need more information. Thank you in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need assistance with Excel 2007
Sub MoveRows()
NewRow = 1 For ShtCount = 1 To 7 With Sheets(ShtCount) For RowCount = 14 To 513 If .Range("Q" & RowCount).Value 0 Then .Rows(RowCount).Copy _ Destination:=Sheets(8).Rows(NewRow) NewRow = NewRow + 1 End If Next RowCount End With Next ShtCount End Sub " wrote: Hello everyone. Ok, here is my issue. I have seven sheets each with a table that is from B14 to U513. In column Q (from row 14 to 513), of each sheet, there is nothing (" ") or a number from 0 and up. Here is what I need. On sheet 1, for each cell in column Q, if the value is null (nothing), move to the next cell. If value is greater then 0, I want to copy the corresponding row onto sheet8. Once sheet 1 is done, i want to do the same operation on the next sheet, then the next, until all 7 sheets are done. Please note that although I am pretty good with formulas, I know nothing about programming macros or VB. But i have a feeling this would be a piece of cake for some pros on here. Let me know if you need more information. Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
assistance need with excel doc | New Users to Excel | |||
Assistance with password in Excel | Excel Worksheet Functions | |||
Excel Formula assistance | Excel Programming | |||
Excel VBA Assistance please. | Excel Programming | |||
Excel VBA assistance for a noobie | Excel Programming |