I have 20 worksheets in EXACTLY the same format in one workbook.
There are 200 numeric fields in each sheet.
I want one SINGLE consolidated sheet with each field "summed".
What is the easiest way to consolidate?
I am aware that Excel has a consolidation function but that seems to force me to repeat keying tasks multiple times. i.e. for each of the 200 numberic fields I would need to repeat the same actions 20 times (i.e. one for each sheet)
Windows Explorer lets you open cabinet (cab) files like any other folder.
In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…