Community of VE/MapPoint Users and Developers
This is a discussion on Cell Link for combo box in Excel : Relative or absolute? within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; Cell Link for combo box in Excel : Relative or absolute? Well, using only 1 combo box is fine without ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| |||
| Cell Link for combo box in Excel : Relative or absolute? Well, using only 1 combo box is fine without caring about cell link's being relative or absolute. But when I copy the cell containing the combo box, I need the cell link to be relative. Here's something to visualize the problem: Think of an order form. I got 100 orders in the list. And I got a column which I want to put a combo box with selections "paid" or "not paid" . Well, I put my first combo box in my first order. But when I copy that cell down for the remaining 99 orders, all the combo boxes that I created (for the other 99 orders) all are linked to the FIRST order's combo box's cell reference. However I want that cell's reference to be relative so that when I copy the cell(and the combo box as well, as that cell contains containing the combo box) their cell link is changed. I need this cos I may have 10000 orders for example and modifying all the cell refeences of all those orders's combo boxes may be annoying. Any help is welcomed. Thanks in advance. |
| |||
![]() |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Link Data to Excel update MP resets or can't place address | GEB | MapPoint 2006/2009 Discussion | 3 | 10-01-2005 04:30 AM |
| Cell phone tracking from AccuTracking | Anonymous | News and Announcements | 1 | 07-27-2005 08:48 PM |
| How can I link Mappoint with Excel? | Anonymous | MapPoint 2006/2009 Discussion | 1 | 10-27-2004 06:17 AM |
| How can I link an Excel pivot table with Mappoint? | Anonymous | MapPoint 2006/2009 Discussion | 0 | 10-27-2004 04:19 AM |
| Copying Worksheet with Combo Box | Anonymous | MapPoint 2006/2009 Discussion | 0 | 07-20-2004 04:13 PM |
Ski Chalets
Don't miss out on the delights of ski chalets. Book accommodation to suit your ski holiday requirement online at Holiday Hypermarket.
Flights to Greece
Find cheap flights to Greece on Travel Counsellors. A personal Travel Counsellor can help you plan flights and find accommodation in Greece.
Flight to Canada
Book a flight to Canada to explore one of the most exciting travel destinations in the world. There are loads of interesting cities but some even more impressive natural beauty.
Sri Lanka Holidays
There are some outstanding deals on Sri Lanka holidays at theholidayplace.co.uk. Sri Lanka is renowned for it's exceptional beauty! Book a holiday today!
Portugal
As well as providing some great weather Portugal has much to offer culturally. There are numerous museums, monuments and places of historical interest to explore. Despite the rich history there is a buzzing nightlife and great shopping too.
Travel Deals
Find the very best travel deals on your prime comparison site, Travel.co.uk
Holidays in Portugal
Find the perfect Algarve holiday. Book holidays in Portugal now at On The Beach.