Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel spreadsheet of Lotto results - formula question

4 Weeks Ago   #21
Paul Black

Win 7 HP SP1 64-bit Vista HB SP2 32-bit Linux Mint 18.3
 
 

Hi teckneeculler,

Quote   Quote: Originally Posted by teckneeculler View Post
Paul, thank you so much, the macros are amazing! I assume they're something like a Word macro, only I won't need to create them, just open and enter the commands you've provided?

Your help has been invaluable!
LOL, gonna start tinkering right away
Yes, they are the same as a Word Macro.

In the Excel Spreadsheet, click the Developer tab => click Macros => enter a name in the Macro name: [i.e Lotto] => click Create => Copy & Paste each piece of code under each other => Save the Excel Spreadsheet.

There are two ways to run the Macros . .

[1] Click Macros => Highlight the Macro to run => click Run.

[2] Create a button for each of the Macros on the Spreadsheet => NAME the Macro button => ASSIGN the Macro you want to run to it.

I hope this helps!


My System SpecsSystem Spec
.
4 Weeks Ago   #22
Paul Black

Win 7 HP SP1 64-bit Vista HB SP2 32-bit Linux Mint 18.3
 
 

Hi teckneeculler, which format did you save the Excel file you uploaded and attached?

EDIT: Not to worry, I was going to upload the Spreadsheet with the Macros etc already in but I can't. I have PM'd you.
My System SpecsSystem Spec
4 Weeks Ago   #23
teckneeculler

Win7Ultimate
 
 

Hi Paul and thanks again
The original Excel file I upped was a 2003. But I think I should be learning to use a newer version - at least 2007, say - so that's what I'm working with at the moment.
The movie looks good, LOL!
Should I change the suffix from mp4 to xlxs?
My System SpecsSystem Spec
.

4 Weeks Ago   #24
Paul Black

Win 7 HP SP1 64-bit Vista HB SP2 32-bit Linux Mint 18.3
 
 

Hi teckneeculler,

Quote   Quote: Originally Posted by teckneeculler View Post
The original Excel file I upped was a 2003. But I think I should be learning to use a newer version - at least 2007, say - so that's what I'm working with at the moment.
You have a PM!
My System SpecsSystem Spec
3 Weeks Ago   #25
Paul Black

Win 7 HP SP1 64-bit Vista HB SP2 32-bit Linux Mint 18.3
 
 

Hi teckneeculler, did the file work OK for you?
My System SpecsSystem Spec
3 Weeks Ago   #26
Paul Black

Win 7 HP SP1 64-bit Vista HB SP2 32-bit Linux Mint 18.3
 
 

Hi teckneeculler, can you please mark this thread as Solved!
My System SpecsSystem Spec
Reply

 Excel spreadsheet of Lotto results - formula question




Thread Tools




Similar help and support threads
Thread Forum
Excel 2013 - how to keep a formula consisten
Hi I am trying to tie one cell into a formula that is being pasted into multiple rows. I know you can use $ to keep the cell consistent but it doesn't seem to be working. So if the value is in c9 and then first row gets c9 then the new row gets c10 etc... I need it to be c9 throughout the...
Microsoft Office
Excel Formula
Hello Sir, Can you let me know the formula in Excel: I have a table as below: This table, At the column "A,Status" when i Put the word" Completed", it's will automatic put current Date to Column "B, Row 2". But i don't know after that when tomorrow arrived,at the column "B,Row 2",...
Microsoft Office
Problem with Excel Spreadsheet
I have to admit that I am not proficient in the MS Excel program. I have to fill in a form for a potential employer but the cell is too small to contain all of the information--the information that I typed in goes "off the page" into neighboring cells that are not part of the form. I can't seem to...
Microsoft Office
Excel 2003 sum formula problem
I have been entering currency data in Column B in Euros to an EXCEL 2003 s/s and the formula used has added these totals entered in that Column correctly until I reached a total sum of 74364.70 Euros ,this being the sum of entries in Rows B6 to B82 . This was reached with the formula showing as...
Microsoft Office
Excel Formula Help please...
This is probably very simple and I have got it working but it isn't working how I want it to work. I have created an Excel document to show my monthly payments of a bank loan. I have created 3 columns in the first column is the payment number, in the second column is the amount that the loan...
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 22:30.
Twitter Facebook