Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Loop thru rows to copy to another excel spreadsheet
Hi everyone. I don't usually deal too much in excel so please excuse
the lack of knowledge. I have a spreadsheet with a fixed number of columns and a variable for the number of rows. I have added a checkbox to each row. The check boxes are in column "A" All I want to do is --- to loop thru each row and If there is a value in column "B" and the CheckBox in column "A" is true, I want to copy that entire row from sheet1 to sheet2. If column "B" has no value (null) then drop out of the loop. I would suppose for someone who knows their way around excel and VB this doesn't seem very difficult but I do not have a clue. Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When Inserting Rows in Excel, not all formulas copy to new row? | Excel Discussion (Misc queries) | |||
why wont my formulas copy all the way down my excel spreadsheet??? | Excel Worksheet Functions | |||
Im trying to remove blank rows in an Excel spreadsheet Printout | Excel Worksheet Functions | |||
how do i copy only the coloured filled rows in excel to new sheet | Excel Worksheet Functions | |||
Can I split up an excel spreadsheet into multiple files by rows? | Excel Discussion (Misc queries) |