| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro lookup
<sheet 1 Week Begining X TITLE X VALUE <- these are the column headings 16 January 2006 23 January 2006 30 January 2006 06 February 2006 13 February 2006 <sheet 2 06 February 2006 <- this date is changed using a spinner 1st column TITLE VALUE 2nd column X TITLE £200.00 these values in the 2nd column need to be pasted into the row in sheet 1 that contains the date given above in sheet 2 sorry if this is not accurate enough -- dudemango ------------------------------------------------------------------------ dudemango's Profile: http://www.excelforum.com/member.php...o&userid=31137 View this thread: http://www.excelforum.com/showthread...hreadid=507998 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Editing a simple macro | Excel Worksheet Functions | |||
| Creating macro to lookup data | Excel Discussion (Misc queries) | |||
| macro with F9 | Excel Discussion (Misc queries) | |||
| Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
| Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Threaded Mode
