Outputting to another excel file

[bobd]

Hello;

I am pretty new to excel and visual basic programming. I have an
excel sheet with 385 items. Each item has a checkbox next to it.
Each item has a 2 line description, making the spreadsheet 1158 lines
including a 3 line heading. It is a restaurant list of food items to
order.

I need a macro that checks if a check box is checked, and if it is,
outputs the item and it's description to another excel file, appending
as items are checked. If possible, i would like the new outputted
file to have the same formatting as the original. I guess this would
mean having a .xls file pre-created for output.

I have tried some vb code and suceeded at getting output to a text
file, but am having difficulty with cell ranges and 2015 errors. I
have researched the print # function, and have tried unsuccesfully
with some loops.

Any help would be really appreciated from those more experienced at
programming.

bobd

 

[Frank Kabel]

Hi
have a look at
http://www.rondebruin.nl/copy5.htm
for a starting point. Link all your checkbox to a cell in the row and
use this column as 'common' value for extraction