Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 78

Autofill issue

I am trying to autofill a formula. I am in cell A12. Assuming that I want
to multiply A10*J1. When I autofill it across, I would like the A10 to
change to A11, A12, etc. However, I want the J1 to change to J2, J3, etc.
Absolutes will not work. I'm sure that this isn't simple multiplication.
Does anyone have a function that will do this? Thanks.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Autofill issue	Cytorak	Excel Discussion (Misc queries)	2	September 24th 08 10:22 PM
AutoFill Macro Issue	Jon	Excel Discussion (Misc queries)	1	March 13th 08 02:19 PM
autofill issue	Arain	Excel Discussion (Misc queries)	0	March 28th 07 01:02 AM
autofill issue	Farhad	Excel Discussion (Misc queries)	0	March 28th 07 12:09 AM
Autofill issue...	nc0229	Excel Discussion (Misc queries)	0	December 13th 04 11:12 AM

All times are GMT +1. The time now is 09:16 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us