Auto Updation

[Newtonboy]

I have two sheets, One is a runing data entry sheet in the following format:

Sl.No./Date/Invoice No./Product Code/Description/Buyer Name/Value.

From this master sheet, I am extracting a summary through vlookup's, and the format is as below:

Buyer Name/Total value.

As of now, if i have a new Buyer Name, I have to manually go and add that name in the summary sheet. Is it possible to find a way whereby, as soon as a new Buyer Name is entered in the Master Sheet, the summary sheet automatically picks it up and enters it in the specified place ?

[Newtonboy]

Pls...Any help ?

[VBA Noob]

Hi,

I'm assuming you want a unquie list of names in the Summary page. If this assumption is correct then you could try this formula in the Summary Sheet from cell A2 (Not A1).

This formula looks at Range A2 to A20 on the Master Sheet and returns the names only once in the Summary sheet. Change the range as required.

It's an array formula so you will need to enter with Ctrl + Shift + Enter.

=IF(ISERROR(MATCH(0,COUNTIF(A$1:A1,'Master Sheet'!$A$2:$A$20&""),0)),"",INDEX(IF(ISBLANK('Master Sheet'!$A$2:$A$20),"",'Master Sheet'!$A$2:$A$20),MATCH(0,COUNTIF(A$1:A1,'Master Sheet'!$A$2:$A$20&""),0)))

VBA Noob