Forum Discussion
Conditional for all sheets
Can't help you much with only an image. My question, as someone who also has created a very ambitious workbook to track all our (my wife's and my) expenditures (check transactions from two checking accounts, credit card transactions from four credit cards)... is why you have separate sheets for all the "raw data"? A far better design is to have all the raw data on a single sheet, in a single data table, differentiating between "business" and "personal" --along with all sorts of other budget categories, etc.,-- is through appropriate use of columns containing those designations. You can then use such things as the Pivot Table to summarize things by month, by category.
Is that something you're open to? I"ve attached a very simple example; it would be easy to add the "business" vs "Personal" data in a single column...... this is meant just to show how readily the Pivot Table takes a single database and analyzes it