change value in a cell according to another cells value82772 (1/19/2006 6:28:02 AM) KylieRose(3)Please help me.... Example: I need to make 1 = $50 and 2 = $100 and 3 = $120 etc I need to do this by entering 1, 2 or 3 in column A and the value automatically appearing in column D, is this possible? Also I...
Macro in excel to save to an unmapped drive !22135 (1/18/2006 11:32:20 AM) robinraw(4)Help... Can anybody hlep me out here... I am trying to construct a macro part of which will save a file to an unmapped drive, i can do this when the filename is static but I need to change the filename cellvalu...
Macro and hidden sheets71817 (1/18/2006 12:51:06 PM) Metallo(10)Hi, I have a WB with 10 worksheets. At the time I did this WB, I also created a Macro that had the task to change the format of all the sheets. Today, I have decided to hide some of the sheets and the macro ...
Define name #201817 (1/19/2006 9:26:12 AM) digicat.21vkry_1137663001.3854(1) Looking for a way to define a name over several Sheets that will apply to the active sheet only. An example: On Sheet1, Sheet2 and Sheet3 in cells A4:G17 I have a form that I want to give one name (e.g. Order...
Moving data between worksheets ...51942 (1/19/2006 8:21:48 AM) iedmont(11)Hi, Wonder if someone can help me please? I have a sheet in a workbook called "Sheet1" (please see www.iedmont.blogspot.com/) and what I am trying to do is move all rows that contain a date into a separate sh...
Excel Standar Colour Palette01848 (1/19/2006 9:12:02 AM) siobhan_roche(1)Does anybody know how to use Pantene colours in Excel cells? Or at least get the RGB option, or load new colours? Would really appreciate help. Thank you ...