I am looking to identify and sum values included on multiple worksheets within a file.
Basically column A consists of identifiers (say A-Z). Column F consists of a dollar value. I would like a macro that could search through all worksheets and populate a new worksheet that would sum up all the values in column F for each identifier A-Z and list these identifiers along with the summed values.
I can do this on one worksheet but the files to which I would like to apply this macro consist of approx 30 worksheets.
Can anyone please give me some advice on this one? I would greatly appreciate it!
Basically column A consists of identifiers (say A-Z). Column F consists of a dollar value. I would like a macro that could search through all worksheets and populate a new worksheet that would sum up all the values in column F for each identifier A-Z and list these identifiers along with the summed values.
I can do this on one worksheet but the files to which I would like to apply this macro consist of approx 30 worksheets.
Can anyone please give me some advice on this one? I would greatly appreciate it!