Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying a row marked with a checkbox Please HELP
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying a row marked with a checkbox Please HELP
On Oct 9, 1:54 pm, "eighthman11" wrote: 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. This shouldn't be a terribly difficult task. Before we dive into it though, may i ask why you are using the check boxes? AR |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying a row marked with a checkbox Please HELP
The spreadsheet has about 3500 rows of data. It gets the data from an
import. Occassionaly the person using the spreadsheet needs to isolate some of the records to print or to email to someone. Thought the checkboxes would be an easy way to earmark those records. On Oct 9, 3:30 pm, "ducky" wrote: On Oct 9, 1:54 pm, "eighthman11" wrote: 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.This shouldn't be a terribly difficult task. Before we dive into it though, may i ask why you are using the check boxes? AR |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting cells that have a checkbox that is marked | Excel Worksheet Functions | |||
Marking cell; totaling all # between marked cell & next marked cel | Excel Worksheet Functions | |||
perform a calculation if checkbox marked | Excel Worksheet Functions | |||
Copying marked rows to another sheet | Excel Programming | |||
Checkbox to be marked with a cross rather than a tick | New Users to Excel |