Audax
11-12-2008, 08:47 AM
Hi, I hope somebody can help me
I have 2 sheets...sheet #1 there is a table with 8 columns and 20 rows
In sheet #2 cell A5 has a 3 digits number which the first digit will represent the column of the sheet #1 and the others 2 digits will represent to the row of the sheet #1. Ex: If A5=612 means column 6 (Column F) and row 12 of the sheet #1.. I want to copy the value that is in this cell (F12) of the sheet #1 in cell B30 of sheet #2.
THANK YOU FOR HELP ME
I have 2 sheets...sheet #1 there is a table with 8 columns and 20 rows
In sheet #2 cell A5 has a 3 digits number which the first digit will represent the column of the sheet #1 and the others 2 digits will represent to the row of the sheet #1. Ex: If A5=612 means column 6 (Column F) and row 12 of the sheet #1.. I want to copy the value that is in this cell (F12) of the sheet #1 in cell B30 of sheet #2.
THANK YOU FOR HELP ME