ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Spread macro (https://www.excelbanter.com/excel-programming/397671-spread-macro.html)

Lefty

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

Jim Cone

Spread macro
 

No macro needed...
Select the 12 columns.
Type in the number.
Hold down the Ctrl key and hit the Enter key.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Lefty"
wrote in message
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


All times are GMT +1. The time now is 09:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com