G
Guest
Hello all,
This one has me confused..completely.
I currently have 10 worksheets in my workbook.
I have a userform used to enter eight items into the first worksheet.
I also have the same userform set to popup on opening each worksheet to do
the exact same thing.
The question is...
Is there a way for me to type "Same" into the first field of the userform an
have it read the cells it filled in from the first worksheet, then place that
info into the current worksheet?
I have studied heaps of copy paste examples, but none seem to demonstate a
way for me to do this.
Regards
Peter
This one has me confused..completely.
I currently have 10 worksheets in my workbook.
I have a userform used to enter eight items into the first worksheet.
I also have the same userform set to popup on opening each worksheet to do
the exact same thing.
The question is...
Is there a way for me to type "Same" into the first field of the userform an
have it read the cells it filled in from the first worksheet, then place that
info into the current worksheet?
I have studied heaps of copy paste examples, but none seem to demonstate a
way for me to do this.
Regards
Peter