Sorry for the nebulous title question but there are only so many words available in the title! I've trawled your site for an hour or 2 already today, but couldn't find anything exactly relevant (or close enough), so thought I'd ask directly.
I'm trying to run a fairly simple Excel spreadsheet showing a summary of all the previous worksheets results.
The 'Summary' sheet format is that A6:A17 are accounting status names (eg. Not started yet, Not Due Yet, Completed etc), range B6:B17 is the number (count) of applicable clients that fall into this category.
I've imported the data from Access into new worksheets within the same workbook and want the summary sheet to autopopulate based on these sheets.
eg. Sheet1 is 'Summary', sheet 2 is '2003-count' (I will be repeating this exercise ad infinitum for each year).
Row 1 in '2003-Count' shows accounting status from an Access query, and only returns those statuses that are applicable in that year - <> (for blank - which we need to amend on our systems!), Annual return filed, and Completed - Row 2 shows the count - 2, 1 and 38.
What formula or macro will I need to populate fields B6:B17 with the relevant amounts from row 2 based on the 'title' in row 1, and populate the ones that have no corresponding 'title' with 0? (Column C is a percentage field, so needs to be a 0 to work).
I used the LOOKUP formula originally and added the IF funtion and the ISBLANK to the mix and still cannot get it to return what I need... and now am so confused it was actually a relief when I accidently closed it and lost the attempts!
Looking forward gratefully to any help you can provide, I can also provide an example of the worksheet if that helps!