Hi All,
I am using Excel 2007. I am trying to prepare new a Excel sheet which will replace a conventional white board usage in my company.Btw I'm new to Excel VBA. Ours is a car rental company we need to track where our vehicles are daily at the end of the day.So this sheet will be updated with a user form at the start of the day for the transit happened on previous day.
What I need:
I have a work book with three sheets. Sheet1 will be displayed when excel is opened. Its the main sheet which will look exactly like the White board with customer name in the 1 st Column(A2 to A20) and car numbers in the range B2 to Q20. It will look something like this.
Sheet1
<tbody>
</tbody> Sheet 2
<tbody>
</tbody>
Sheet 3 is look up list. It has values which forms the named ranges and is used get values in sheet2.
The data in sheet 2 is obtained with a user form with many combo box and text boxes using Excel VBA.
My question is how extract data from sheet 2 Like what I have in Sheet 1 using EXcel VBA code. I want it to be sorted for individual days with customer in Column 1 and the vehicles arranged accordingly based on the date.
Thanks for your help.
Ganesh
I am using Excel 2007. I am trying to prepare new a Excel sheet which will replace a conventional white board usage in my company.Btw I'm new to Excel VBA. Ours is a car rental company we need to track where our vehicles are daily at the end of the day.So this sheet will be updated with a user form at the start of the day for the transit happened on previous day.
What I need:
I have a work book with three sheets. Sheet1 will be displayed when excel is opened. Its the main sheet which will look exactly like the White board with customer name in the 1 st Column(A2 to A20) and car numbers in the range B2 to Q20. It will look something like this.
Sheet1
Customer Name | Car numbers | |||
Customer 1 | 1234 | 3214 | 4661 | 6548 |
Customer 2 | 5216 | 6546 | ||
Customer 3 | 4561 | 8462 | 6464 | |
Customer 4 | 2465 | 1642 |
<tbody>
</tbody>
Date | Driver | Customer | Car numbers | TIme |
8/8/14 | ABC | Customer1 | 3214 | 9:00 |
9/8/14 | ABG | Customer2 | 2451 | 10:00 |
8/8/14 | GFD | Customer1 | 5663 | 5:00 |
9/8/14 | GHF | Customer3 | 4561 | 6:00 |
<tbody>
</tbody>
Sheet 3 is look up list. It has values which forms the named ranges and is used get values in sheet2.
The data in sheet 2 is obtained with a user form with many combo box and text boxes using Excel VBA.
My question is how extract data from sheet 2 Like what I have in Sheet 1 using EXcel VBA code. I want it to be sorted for individual days with customer in Column 1 and the vehicles arranged accordingly based on the date.
Thanks for your help.
Ganesh