Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spread Macro
I am trying to Do a spread Macro for budgeting. I want to specify a column
when a number is entered and I hit the Macro button that number would be spread in the same row in 12 (months) columns |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spread Macro
If you just want to enter a value and copy it across then:
1. Select A1 thru L1 2. type a number 3. Instead of touching the ENTER key, touch CNTRL-ENTER If you want to distribute values into 12 equal parts, then you would need a macro: Sub fillum() v = Range("A1").Value / 12 Range("A1:L1").Value = v End Sub -- Gary''s Student - gsnu200745 "Lefty" wrote: I am trying to Do a spread Macro for budgeting. I want to specify a column when a number is entered and I hit the Macro button that number would be spread in the same row in 12 (months) columns |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create a macro to search an excel spread for duplicates | Excel Worksheet Functions | |||
how do i enter a bull call spread into the options spread sheet ? | Excel Worksheet Functions | |||
is there anyway to make it so the users of my excel spread sheet cant view the macro code w/o a password? | Excel Worksheet Functions | |||
I want to create a macro to where after we enter data in a spread. | Excel Worksheet Functions | |||
Spread Sheet Help again | New Users to Excel |