My excel spreadsheet contains dates in the first row of my worksheet. In the first column of my worksheet there are Layout Numbers, so there would be a number of products related to that layout Number ex All Sweets would be under layout No 16 etc. In my userform i have two textboxes, I want to be able to type in two dates in the two textboxes, i will then have a another textbox where i can type in the Layout No.

When i click a command button then i was hoping that it will find the layout No and its products associated with that, pick all the dates between the two dates in the textboxes and generate a bar chart with the dates on the x axis and the products on the Y axis. I know this must be really complicated but any help would be greatly appreciated.

Thanks