[FONT="]Hello, I am making a spreadsheet for the calculation of stiffness, a series of very extensive engineering calculations that requires a very meticulous selection of data, so part of them require manual data pasting when making formulas[/FONT]
[FONT="]The spreadsheet calculates the following data for what we will call a bar
[/FONT]
[FONT="]This contains a total of 16 data, according to the numbering in row and column from 1 to 87 (Nx, Ny, Fx, Fy) for each bar.[/FONT]
[FONT="]Then this data has to be stored in 4x4 ranges(=linked) in an 87x87 matrix according to the row and column number mentioned above
[/FONT]
[FONT="]this whole process must be repeated for each bar[/FONT]
[FONT="]I tried using IF conditional format, but the ranges for the autofill are differentI thought about using the vlookup but I will get the same error when using autofill, or at least I don't have enough experience with this command[/FONT]
[FONT="]The spreadsheet calculates the following data for what we will call a bar
[/FONT]
[FONT="]This contains a total of 16 data, according to the numbering in row and column from 1 to 87 (Nx, Ny, Fx, Fy) for each bar.[/FONT]
[FONT="]Then this data has to be stored in 4x4 ranges(=linked) in an 87x87 matrix according to the row and column number mentioned above
[FONT="]this whole process must be repeated for each bar[/FONT]
[FONT="]I tried using IF conditional format, but the ranges for the autofill are differentI thought about using the vlookup but I will get the same error when using autofill, or at least I don't have enough experience with this command[/FONT]