Hi
I need some help to figure out how I get one sheet of data to auto-populate another. I have a sheet of source data wich includes:
Start date
end date
lead
booking ref
overseas comments
I have a calendar that I wish to populate based on the above. The key is to get the startdate and enddates from my source data into the correct cells in my calendar.
See my sample attached. Any help would be great.
I had to change the format of your calendar a little bit. Where you have typed in numbers for the days of the month, you have to use dates. You can then format them any way you want; I used d/m but you could just show the day number if you want. Same for days of the week; those are also dates, formatted to show an abbreviation for the days of the week. The reason for doing it this way is that you avoid manual errors, such as the one in your worksheet where the days of the week were off.
See "Calendar (2)".
Hi, thanks so much for your help! this is bang on. Kon
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks