grohm
03-26-2007, 05:17 AM
hi guys. this is my first post here and im also pretty new to VBA but im on my way to learn.
my problem is the following. on the first sheet in the file you are supposed to make entries. this entries sum up in the 2nd sheet. now from that sheet some of the data needs to go to a 3rd sheet, which is a list. after that the data in the 2nd sheet can be deleted since its only a temporary "datasave"
the problem is, that this 3rd sheet is a list. the data needs to be added and it needs to keep previous rows of data.
for example: i push the button on sheet 1 and it makes a row of data in sheet 3. after that i enter different data in the first sheet and want that data to be a row below the previous data.
this is keeping me busy for some hours now and i have not found a useable soluion....hope you can help. thx!!!!
my problem is the following. on the first sheet in the file you are supposed to make entries. this entries sum up in the 2nd sheet. now from that sheet some of the data needs to go to a 3rd sheet, which is a list. after that the data in the 2nd sheet can be deleted since its only a temporary "datasave"
the problem is, that this 3rd sheet is a list. the data needs to be added and it needs to keep previous rows of data.
for example: i push the button on sheet 1 and it makes a row of data in sheet 3. after that i enter different data in the first sheet and want that data to be a row below the previous data.
this is keeping me busy for some hours now and i have not found a useable soluion....hope you can help. thx!!!!