• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Match year then find earliest date of year (in a range) and return cell adress of date

Hi Narayan:

Awesome, it worked perfect as I wanted. Bundle of thanks for help.

As per your suggestion, I should start learning. I am learning but complex formulas are really complex for me to do and working on to understand. Learned lot from you guys.

Thanks again.

Riaz
 
Hi Narayan:

Following excel sheet was prepared to plot the charts (through your help).
Here is scenario how it works.
Columns: A to H, contains data that we enter weekly bases, remaining all columns are calculated and then charts are plotted.
In cell BJ4 & BJ5, we enter years range (start year and end year to plot charts). In cells BK4 & BK5, it returns row number of selected years (start year first date, end year last date). then these row numbers passed to defined range names to plot charts dynamically.
Up to here it works what we want. But we have more than one products, we need to create copies of this master sheet in same workbook. When we copy and give new name to sheet, data and charts are being taken from original/master sheet. Looks like defined name are working on workbook level.

What we want now, is there any simple macro or VBA code that makes range names available to local/active sheet. where we can enter data and select range of years locally and it should displays charts based on current/active sheet data in same workbook.

I am not looking to make big changes on current functionality because it is fully tested and working fine but looking for addition.

Sample file is too big can not upload here but have sent you via email.

Thanks
 
You must log in or register to reply here.
Back
Top