P
philcud
Hi all,
i have a spreadsheet with data validion on a cell (a1 on sheet1)
linked to a list on a separate sheet. this list has a few hundred
items.
i need to loop thro the list, calculate and save the workbook as the
cell contents of sheet A1 and continue thro the list.
I know this can be achieved by vba, but it has been sometime since i
delved into writing my own loops in vba. and help would be
appreciated.
thanks
i have a spreadsheet with data validion on a cell (a1 on sheet1)
linked to a list on a separate sheet. this list has a few hundred
items.
i need to loop thro the list, calculate and save the workbook as the
cell contents of sheet A1 and continue thro the list.
I know this can be achieved by vba, but it has been sometime since i
delved into writing my own loops in vba. and help would be
appreciated.
thanks