UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Macro That Will Calculate Rows And Columns, Office 2013    
 
   
billwild
post Aug 31 2019, 11:00 AM
Post#1



Posts: 110
Joined: 4-June 02



This is a little difficult to explain so I've included a spreadsheet.
I would like to be able to input a number for the number of rows to calculate and then have the macro build the spreadsheet as shown A4:L13.

Thanks, Bill


Attached File(s)
Attached File  NumberCalc.zip ( 7.55K )Number of downloads: 3
 

--------------------
always learning....<img src="/forums/images/graemlins/laugh.gif" alt="" />
Go to the top of the page
 
arnelgp
post Aug 31 2019, 12:46 PM
Post#2



Posts: 1,478
Joined: 2-April 09
From: somewhere out there...


use macro enabled excel sheet.
Attached File(s)
Attached File  NumberCalc.zip ( 27.51K )Number of downloads: 2
 

--------------------
Never stop learning, because life never stops teaching.
Go to the top of the page
 
billwild
post Aug 31 2019, 02:27 PM
Post#3



Posts: 110
Joined: 4-June 02



PERFECT!!!! THANK YOU SO MUCH

--------------------
always learning....<img src="/forums/images/graemlins/laugh.gif" alt="" />
Go to the top of the page
 
billwild
post Aug 31 2019, 02:48 PM
Post#4



Posts: 110
Joined: 4-June 02



Sorry to bother you again but can you add to the macro (or add a new one) that will export ONLY the result (from column "L") to a txt file on the desktop?

--------------------
always learning....<img src="/forums/images/graemlins/laugh.gif" alt="" />
Go to the top of the page
 
billwild
post Aug 31 2019, 03:00 PM
Post#5



Posts: 110
Joined: 4-June 02



Oops. I forgot to tell you that I only want the output to always be 10 columns. For example If I input 5 the result would be:

001, 006, 011, 016, 021, 026, 031, 036, 041, 046
002, 007, 012, 017, 022, 027, 032, 037, 042, 047
003, 008, 013, 018, 023, 028, 033, 038, 043, 048
004, 009, 014, 019, 024, 029, 034, 039, 044, 049
005, 010, 015, 020, 025, 030, 035, 040, 045, 050

--------------------
always learning....<img src="/forums/images/graemlins/laugh.gif" alt="" />
Go to the top of the page
 
billwild
post Aug 31 2019, 06:48 PM
Post#6



Posts: 110
Joined: 4-June 02



Did you understand my last post?

--------------------
always learning....<img src="/forums/images/graemlins/laugh.gif" alt="" />
Go to the top of the page
 
arnelgp
post Sep 1 2019, 05:06 AM
Post#7



Posts: 1,478
Joined: 2-April 09
From: somewhere out there...


here is you xlsm
Attached File(s)
Attached File  NumberCalc.zip ( 33.41K )Number of downloads: 1
 

--------------------
Never stop learning, because life never stops teaching.
Go to the top of the page
 
billwild
post Sep 1 2019, 07:34 AM
Post#8



Posts: 110
Joined: 4-June 02



you are totally awesome. I have had to rely for the last 20 years on the experts here at UtterAccess. My lifesaver!!!!

--------------------
always learning....<img src="/forums/images/graemlins/laugh.gif" alt="" />
Go to the top of the page
 
arnelgp
post Sep 1 2019, 09:22 AM
Post#9



Posts: 1,478
Joined: 2-April 09
From: somewhere out there...


goodluck and happy weekend!

--------------------
Never stop learning, because life never stops teaching.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    21st October 2019 - 10:05 AM