Copy from worksheet to another x times
I'm trying to create a spreadsheet that will copy Worksheet A Cell B5 to Worksheet B Cell B5 and Worksheet A Cell B6 to Worksheet B Cell C5 'X' Times but, Worksheet A Cell B5 will be increasing by 1 until it reaches the 'X' times. When this is done I then want my worksheet to generate 'X' (this is inputed by the user) how many times the Worksheet will generate after Worksheet B Cell B5 and C5. For example: Worksheet A Cell B5 = 123 Cell B6 = 6 Number of times input by user: B7 = 10 Worksheet B Cell B5 = 123 Cell B6 = 6 Cell B5 = 124 Cell B6 = 7 ... Cell B5 = 132 Cell B6 = 6 If you need any more info just post. Any help is welcomed. Thanks, John -- Union70 |
All times are GMT +1. The time now is 03:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com