If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below. If you don't like Google AdSense in the posts, register or log in above.

Merge Duplicates then Sum and Count values

I often need to merge multiple occurences of data (tax addresses & tax names) and to sum or count the values associated with each invividual instance (i.e number of units per tax address). Data can often be thousands of rows and varies every time. I would like to keep all of the associated information with each entry for mailing purposes. I saw this link...http://www.ozgrid.com/forum/showthread.php?t=83101

However, the VBA macro, when run, only keeps my tax address an the associated sum. Please let me know if there is a way to alter the code to make this possible. I will attach the file I am working with....

Email Cell Data Based On Dates In Column

hi guys,

i need something to do the following, i have column with dates that their finish date is after 60 days and i need to be notified 15 days before they end with an email that will attach a text from a cell in the same raw in the email's body.

Ozgrid is Not Associated With Microsoft. Ozgrid Retains the Rights to ALL Posts and Threads

All times are GMT+8. This page was generated at 1 minute ago.

Working...

X

We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. We may share certain information about our users with our advertising and analytics partners. For additional details, refer to our Privacy Policy.

By clicking "I AGREE" below, you agree to our Privacy Policy and our personal data processing and cookie practices as described therein. You also acknowledge that this forum may be hosted outside your country and you consent to the collection, storage, and processing of your data in the country where this forum is hosted.