Hi, All,
I have some 80000 rows of data for some 1600 customers, out of that I have to find last Billing date for each customer.
Sample Data is given as below. Please help me out.
Distributor Code Invoice Date
305226 20-Jan-12
305309 21-Jan-12
305314 22-Jan-12
305315 23-Jan-12
305218...
Hi,
I have a data of Customers and their Monthly Invoicing details in MOM format as shown below. Now, I want to find their first month when they invoiced and also calculate their first six months of total business.
Data is as below for reference:-
Customer Jan/10 Feb/10 Mar/10 Apr/10...
Hi,
I want to protect my data sheet so that it can not be opened on any PC (other than specified one).
I want to create a macro which stores "Computer Name"/"User Name" then matches on finding the current "Computer Name"/"User Name", if it does not matches then file closes or does not open...
Hi,
I am facing one problem in my office. I have one file with confidential sales data which is shared to some of our team members. And it is updated on monthly basis.
Now, for the fear of data might be misused, we want that this data to be protected.
This file is kept at one of our office...
we have a data set like this-
Region City
North JAIPUR
North DELHI
East KOLKATA
East PATNA
South BANGALORE
South CHENNAI
Now in other sheet, I have created a drop down list of Regions in A1, Now I want that all the cities of selected region to be shown from B1 to B9999.
Please help...
I have uploaded the Demo Sheet and also explained the result I need.
https://rapidshare.com/files/961030234/Demo_Sheet.xls
Thanks in Advance for your support