Excel programmimg? database query?

  • Thread starter Thread starter hahu12345
  • Start date Start date
H

hahu12345

Hi there,

I wonder if someone can help me out on this.

I have one excel spreadsheet (1) in which I make some calculation
(Cells G1:AH500) for some given starting values (A1:F500). In a
adjacent spreadsheet (2) I make other types of calculations, into whic
I plug initial values: these initial values are used to calculate cell
E2:E200, which are used to calculate F2:F200 and so on, until we ge
the results in I2:I200.

Now, how can I tell excel to plug the values of A1:F1 in spreadshee
(1) into spreadsheet (2), give me the output in the field
AH1:(AH1)+100 of spreadsheet (1); then take the values of A2:F2
calculate the stuff in spreadsheet (2) and paste results I2:I200 int
AH2:(AH2)+100 of spreadsheet (1)?

Best regards,
Han
 
I don't follow everything, but in your desired cell in Sheet2, enter

=Sheet1!A1

to get the Sheet1, cell A1's value in Sheet2.

I'm not sure how you want to paste 199 values (I2:I200) into 101 cells
[AH2:(AH2)+100]
 
Back
Top