View Single Post
  #1   Report Post  
Union70
 
Posts: n/a
Default 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