hi
i have a list of account number that i want to put into an array or something like that they have to be hard code in as there are not in excel file.
i have kind of rules for each different acc number.
when i pick a certain account number i want it to find certain words in a certain workbook pick that word and the value in next cell and write that to a new workbook
anyone any ideas how this can be done
for exaple here is my list of acc number 101, 102,103,104,105
so i pick say 101 thats says go to worksheet2 and pick total cash balance and say the value in cell beside it is 100
it then write it like this in new work sheet
101 total cash balance 100
and then i pick the 102 acc and it does the same and so on till the end
i have a list of account number that i want to put into an array or something like that they have to be hard code in as there are not in excel file.
i have kind of rules for each different acc number.
when i pick a certain account number i want it to find certain words in a certain workbook pick that word and the value in next cell and write that to a new workbook
anyone any ideas how this can be done
for exaple here is my list of acc number 101, 102,103,104,105
so i pick say 101 thats says go to worksheet2 and pick total cash balance and say the value in cell beside it is 100
it then write it like this in new work sheet
101 total cash balance 100
and then i pick the 102 acc and it does the same and so on till the end
