Excel
Closed
sabregas
Posts
1
Registration date
Monday May 9, 2011
Status
Member
Last seen
May 9, 2011
-
May 9, 2011 at 09:22 PM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - May 12, 2011 at 05:47 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - May 12, 2011 at 05:47 AM
Hello,
I have created a calendar in excel, it can update automatically once the year is entered. I have another sheet "Customers" with "customers list" and the date to be contacted. May be in same date i have to contact 2 to 3 customers to contact.
How can i do a autopopulation of customers list to my calendar? Currently i have created a column with vlookup in "Customers" sheet and i link to my calender sheet from 01/01/2011 to 31/12/2011. It can update only for one year, after one year the dates are chaged so i need to relink to sheetCutomers to sheetYear. What can i do to autopopulate the customers list on each day of my calendar and it can automatically update every year?
Waiting for your reply.:)
Thanks and Regards,
Sabitha
I have created a calendar in excel, it can update automatically once the year is entered. I have another sheet "Customers" with "customers list" and the date to be contacted. May be in same date i have to contact 2 to 3 customers to contact.
How can i do a autopopulation of customers list to my calendar? Currently i have created a column with vlookup in "Customers" sheet and i link to my calender sheet from 01/01/2011 to 31/12/2011. It can update only for one year, after one year the dates are chaged so i need to relink to sheetCutomers to sheetYear. What can i do to autopopulate the customers list on each day of my calendar and it can automatically update every year?
Waiting for your reply.:)
Thanks and Regards,
Sabitha
Related:
- Excel
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Excel marksheet - Guide
- Gif in excel - Guide
1 response
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
May 12, 2011 at 05:47 AM
May 12, 2011 at 05:47 AM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.
Note: your data need not be to be real data but a good representative of how data looks like
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.
Note: your data need not be to be real data but a good representative of how data looks like