| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for comparing Hotel Prices
Hello,
I am getting crazy tryng to compare hotel prices between two given dates in a large sheet. I got some results with thousands of IF and Hlookup formulas. Do you have any listing that I may adapt for this use to have a macro calculating the amount column? It looks like: From Jun 20 to Sep 9 Date Jan1 Jun10 Aug30 Sep30 Dec31 Totals HotelA FB ฌ 50,00 80,00 90,00 75,00 60,00 4900 HotelA BB ฌ 40,00 50,00 70,00 55,00 50,00 3200 Date HotelB FB ฌ 00,00 70,00 90,00 70,00 00,00 4600 HotelB BB ฌ 00,00 00,00 00,00 00,00 00,00 0 Thank you for your help! -- dilettante (=beginner) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing dientical part numbers but with different prices | Excel Discussion (Misc queries) | |||
| How to use Macro to capture snapshots of RTD prices? | Excel Discussion (Misc queries) | |||
| excel 2003 help comparing prices for lowest | Excel Worksheet Functions | |||
| Use a multiplier to change List Prices to Net prices | Excel Worksheet Functions | |||
| Comparing Items and Prices in Excel | Excel Programming | |||
Threaded Mode
