Dynamic ranges

**huzzug** · 09-29-2013, 02:27 AM

Hi all. I have a situation where i work for a small mart. They have a copy of office 07 installed and i want to manage their invoicing through excel. The way i am doing now is to create a master inventory sheet which gets updated each time a new item gets purchased. But the person operating is not too computer literate and does some mistake from time to time. The workbook has two sheet where on the first sheet is the format of the invoice with formulas picking the item and customer info from the 2nd sheet. I attached a sample file to help

**alansidman** · 09-29-2013, 02:43 AM

You will need to supply more information on specifically what you are attempting and need help with. Blank forms without an explanation are difficult to analyze. What data is being entered and what do you want to happen after it is entered. Is the data entered manually or imported electronically? More details. What are the current issues?

**huzzug** · 09-29-2013, 03:03 AM

oops sorry!! Updated the excel

**benishiryo** · 09-29-2013, 05:39 AM

welcome to the forum, huzzug. you can try this array formula:

Formula:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

**huzzug** · 03-02-2014, 08:58 AM

Well, now the previous one worked wonders, but now i'm trying to create a similar sheet, but can't seem to implement the formula above into the new sheet. Would you try to explain the main points in the above formula that i should alter/reference, so that the above formula is easier to implement across my other workbooks as well