madona33
10-21-2008, 01:57 AM
Hi everyone,
I need your help again. I've created an excel document with 3 sheets, a user form with 3 check boxes and text boxes (this document should be like a data bank). I would like to have it like following:
when I check the first check box the right sheet should be activated and the data I want to export to the right sheet should go to the right column and to the next empty row (line). Every sheet (3 sheets) has 9 columns and 300 rows ( I know how to export the data from textbox to the sheet but I don't know how to send it to the next empty column/row)
The first column is the number of the row and I would like it to update itself to the next no when I enter the data ( if the last no is 10 then the date should be exported to line 11 and the column no should be 11 automatically).
Could anybody help please
Thanks a lot
Madona
I need your help again. I've created an excel document with 3 sheets, a user form with 3 check boxes and text boxes (this document should be like a data bank). I would like to have it like following:
when I check the first check box the right sheet should be activated and the data I want to export to the right sheet should go to the right column and to the next empty row (line). Every sheet (3 sheets) has 9 columns and 300 rows ( I know how to export the data from textbox to the sheet but I don't know how to send it to the next empty column/row)
The first column is the number of the row and I would like it to update itself to the next no when I enter the data ( if the last no is 10 then the date should be exported to line 11 and the column no should be 11 automatically).
Could anybody help please
Thanks a lot
Madona