I have spent all night trying to figure this out. As you can tell I know nothing about arrays or how to reference them correctly. Iwould like a "reminder" list to incorporate on the "register" sheet. I've done my best to try and copy and paste and modify the formula to reference my "data" sheet and associated fields, but no success. I've attached both files, the Monthly-Buget is the main worksheet and the Bill-Reminder worksheet. When you open the bill-reminder the arrray pulls data from a table on another worksheet "bills". I want to replicate that on my "Monthly-Household Budget" workbook on the "Register" sheet. I tried copying and pasting the array formula and tried to modify the forumla to meet my needs, but I can't get it to pull my data.
Bookmarks