Terry Echols
Member
I'm in need of some programming. This time it will be to pull all invoices in all current customers spreadsheets.
Nebu:
Since I'm still getting duplicates, no fault of your programming, I have traced it down to invoices remaining on spreadsheets even though they have been paid. This is due to some customers not using us very frequently so the spreadsheets don't get opened very often.
By pulling all individual invoices from all spreadsheets I'll be able to go through them and remove those that are old and will cause duplicates in the purchases macro.
Headers:
Name; Date; Type, Invoice #; Description; Address; Amount & Balance
Programming specifics:
Name - F6
Date - A13-A38
Type - (PUR or REP) B13-B38
Invoice # - C13-C38
Description - D13-D38
Address - E13-E38
Amount - F13-F38
Balance - I13-I38
No need for totals. This is just to pull the information to one sheet so I can then go and clean up the customers spreadsheets.
I've uploaded a few test customers sheets for you.
Nebu:
Since I'm still getting duplicates, no fault of your programming, I have traced it down to invoices remaining on spreadsheets even though they have been paid. This is due to some customers not using us very frequently so the spreadsheets don't get opened very often.
By pulling all individual invoices from all spreadsheets I'll be able to go through them and remove those that are old and will cause duplicates in the purchases macro.
Headers:
Name; Date; Type, Invoice #; Description; Address; Amount & Balance
Programming specifics:
Name - F6
Date - A13-A38
Type - (PUR or REP) B13-B38
Invoice # - C13-C38
Description - D13-D38
Address - E13-E38
Amount - F13-F38
Balance - I13-I38
No need for totals. This is just to pull the information to one sheet so I can then go and clean up the customers spreadsheets.
I've uploaded a few test customers sheets for you.