Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SIMPLE DRAGGING issue
Ok so here's the issue, I want to do this:
In cell A1 "=$M3", B1 "=$M4", C1 "=$M5" A2 "=$M6", B2 "=$M7", C2 "=$M8" and so on... Issue is i have to repeat the reference about 1000 times and I can't manually input. I tried to highlight across and drag down but when I do that I get: In cell A1 "=$M3", B1 "=$M4", C1 "=$M5" A2 "=$M4", B2 "=$M5", C2 "=$M6" and so on... does that make sense? I essentially need to drag the simplest thing through a range in 'box' format and have it count consecutively. (I tried it without making M absolute and it didn't work either) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SIMPLE DRAGGING issue
Leave $M absolute
In A1: "=$M3" In A2: "=$M6" In B1: "=$M4" In B2: "=$M7" In C1: "=$M5" In C2: "=$M8" Select A1:C2 and drag down, select Fll series if Excel dowsn't do it automatically. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple SetFocus on userform issue | Excel Programming | |||
Simple sort issue | Excel Discussion (Misc queries) | |||
Really strange issue with simple formula | Excel Worksheet Functions | |||
Simple Paste Issue | Excel Programming | |||
simple time sheet issue | Excel Discussion (Misc queries) |