Eville
02-05-2009, 12:39 AM
Hello,
Is it possible to instant copy data from B8:B12,B18:B22 etc (from logsheet sheet)from one sheet to another sheet in cells B4:F4,B5:F5 etc (to data sheet)in a way that no double data is placed on the second sheet but with a formula (so no macro). Also the amount of sheets expand because new sheets are made. I will add a draft version of what i try to make so u have an idea ...
Everytime you press 'nieuw logsheet' button, the workbook will be expanded by one logsheet.
The data needs to be transferred automatically with a formula from logsheet to data and there needs to be a certain check that no double coil numbers is placed on the data sheet.
The logsheets must remain untouched, not made hidden or been removed after copying the data to the data sheet.
Last thing: the data on the datasheet have the purpose to be imported into other excel sheets so there must actually be placed data into the cells ><
Is this possible? I know its a big questions but i hope one of you genius have a brilliant idea because im out of ideas ><
Thx in advance!
Ev
Is it possible to instant copy data from B8:B12,B18:B22 etc (from logsheet sheet)from one sheet to another sheet in cells B4:F4,B5:F5 etc (to data sheet)in a way that no double data is placed on the second sheet but with a formula (so no macro). Also the amount of sheets expand because new sheets are made. I will add a draft version of what i try to make so u have an idea ...
Everytime you press 'nieuw logsheet' button, the workbook will be expanded by one logsheet.
The data needs to be transferred automatically with a formula from logsheet to data and there needs to be a certain check that no double coil numbers is placed on the data sheet.
The logsheets must remain untouched, not made hidden or been removed after copying the data to the data sheet.
Last thing: the data on the datasheet have the purpose to be imported into other excel sheets so there must actually be placed data into the cells ><
Is this possible? I know its a big questions but i hope one of you genius have a brilliant idea because im out of ideas ><
Thx in advance!
Ev