Hi all,
My main task is to import data into *.xls file from another excel. The macro I need have to read cells values and then use this values to determinate where to put the data.
In my case, for every row, using values from A to G will determinate where to put the value of H in the other .xls file.
I have to compare the values from first.xls to blank.xls as:
Column A with Row 7, Column B with Row 6, Column C with Column C, Column D with Column D, E with E, F with F, G with G.
For example H2 must be where Row 7 have value 31, Row 6 have value NUMS, C have value A, D have value L1, E have value OO1Y, F have value BGN and column G have value R. Here the value from first.xls of H2=2 must be placed in cell U12 in blank.xls.
And this should be done for all rows in first.xls.
Sorry for the complicated explanation but it’s sound more complex than it is.
http://imageshack.us/photo/my-images/546/capture3rf.png/
10x
My main task is to import data into *.xls file from another excel. The macro I need have to read cells values and then use this values to determinate where to put the data.
In my case, for every row, using values from A to G will determinate where to put the value of H in the other .xls file.
I have to compare the values from first.xls to blank.xls as:
Column A with Row 7, Column B with Row 6, Column C with Column C, Column D with Column D, E with E, F with F, G with G.
For example H2 must be where Row 7 have value 31, Row 6 have value NUMS, C have value A, D have value L1, E have value OO1Y, F have value BGN and column G have value R. Here the value from first.xls of H2=2 must be placed in cell U12 in blank.xls.
And this should be done for all rows in first.xls.
Sorry for the complicated explanation but it’s sound more complex than it is.
http://imageshack.us/photo/my-images/546/capture3rf.png/
10x
