asked on
Add One or Two draws, Copy N Paste, Font Resize and Keyboard Shortcut
Adding One or Two draws option
Apart from entering 4 draws per day manually, if you could kindly provide the option to enter One or Two draws as well and then update the Main tab after clicking add draws button. This option would allow me to view my chances and help play the next draw, instead of waiting for 4 draws per day and then viewing my chances for 10 am draw of the next day.
Copy and Paste
One thing that you could do is to make a copy of the manual draws worksheet in another workbook and copy them from there
Help in understanding how to create a copy of manual draws into another workbook.
Font Resize
At the moment some of the number fonts in Row 3(hit counts) of the 1 to 80 tab are quite small Example Column k, y, z, aa, ab, ac are quite small and thus making it harder for me to see and have to use + and -
If you could kindly resize those fonts to make it larger like the rest of them, as I view Row 3 everytime to check on my chances.
Keyboard Shortcut
At the moment I have to keep pressing + or - at the bottom right with the mouse
If you could kindly provide a Keyboard shortcut to do the same.
- Right-click on the row number in row 3
- Choose Format Cells...
- At the top of the new window, choose Font
- Click the font size that you want from the Size column
- Click OK
- Save the workbook
To create a copy of manual draws into another workbook:
- Right-click in the tab name
- Choose Move or Copy...
- In the new window, select the dropdown arrow under To book:
- Choose (new book)
- Ignore Before sheet:
- Check Create a copy
- Click OK
29242002.xlsb
ASKER
ASKER
I will correct the font size in row 3 problem in the solution to this question, but if you need to do it (you only need to do this once):
Thanks done.
This is how it looks in the picture, I applied a color blue font to differentiate the numbers between row 2 and row 3.
However there is no option to partially bold the font , if I use full bold then it looks smudged color.
The color blue in the above looks thicker than in the actual excel workbook which looks very thin.
I have an updated file till 26th June from the lotto serverI thought you might have a workbook of yours after Jun 22 that you might need me to update. You can download that new Keno workbook yourself.
I applied a color blue fontB3 had a white font color so it looked like there was nothing in it and you should probably restore that color in B3.
ASKER
I thought you might have a workbook of yours after Jun 22 that you might need me to update
Yes I downloaded from the server and updated it.
File attached 29241575i27Morn22.xlsb
B3 had a white font color so it looked like there was nothing in it and you should probably restore that color in B3
Not sure what you meant here.
ASKER
The update from server downloaded in the 29241575i27Morn22.xlsb file.
But the download not working in the 29242002.xlsb file.
Could you kindly check the download at your end.
cf302fb2-f58a-11ec-b04c-39b3d736f4ad.xlsx
Do you see the word "Time" peaking out under the arrow? I'm suggesting that that cell should be white so that it appears to be empty. To do that, carefully select the cell and not the arrow which is resting above it and give it a white font color just like you gave the rest a blue font color.
Note that you should just try to clear it since the word "Time" needed there for filtering purposes.
ASKER
ASKER
ASKER
29241575i27Morn22bluefont.xlsb
I messed up with the B3 cell . not sure how to fix i.t
ASKER
Not sure if the lotto server suddenly went down or not or if it is the file ?
I cannot test the 29242002.xlsb file because the download from the server is not happening.I'm confused because If you are trying to download my workbook then that has nothing to do with the lotto server.
Not sure if the lotto server suddenly went down or not or if it is the file ?
ASKER
The above picture is suitable one.
ASKER
I will try again now
29241575iredwhiteandblue.xlsb
ASKER
That blue fill is too dark.
If you could kindly use the blue color in the above picture with the white numbers
The color depth looks different in EE page and in the actual excel workbook.
ASKER
I was just able to. I was just able to.
I am not having any luck to update the results . Following is the error message.
Could you kindly update your vba edits for one or draws and keyboard shortcut using the below file 29241575iredwhiteandblue.xlsb which is updated till 26th June. You also have copy of that file
ASKER
Unfortunately , the 1 to 80 tab populated 26th June , instead of 27th June in below picure
Also it asked me how many draws and I typed "1" but it populated 4 draws as above.
Have you set it populate 4 draws anyway ? and then do I have to delete the rest of the draws ?
ASKER
Also how do I use the Keyboard shortcut for the magnifier ?
Also it asked me how many draws and I typed "1" but it populated 4 draws as above.In all the past versions of this workbook I've always shown full days worth of draws rather then just one draw. When you 'Select Draws' you are shown full-days worth of draws and that's why I did the manual draws like I did. If you really want me to give you the ability to show for example just one of the draws in a given day I will try to do that, but please confirm that when you type "1" and you haven't previously added any draws that you would like to be shown the 10 AM draw.
...is it possible to make it Half-Bold...There is no half-bold property.
Also how do I use the Keyboard shortcut for the magnifier ?I'm not 100% sure what you mean but does this help?
ASKER
I updated your workbook file 29242002 to 26 June.
And then I clicked on Manual draws tab and it should have given me option to enter 27th June draws.
But instead it auto populated older draws in below picture
The 25 an 26 June draws are already updated in the Main tab until 26th June.
So what I needed to see was the 27 June draw in the Manual draws tab
ASKER
After updating to 26th June draws, the color fonts returned to black.
File attached to show the reset. 29242002 (1)Color Reset in 1to80tab.xlsb
ASKER
please confirm that when you type "1" and you haven't previously added any draws that you would like to be shown the 10 AM draw" comment
Please apply that for the 1 to 80 tab only
ASKER
ASKER
Please apply that for the 1 to 80 tab onlyI can't do that and in any case that's a change of requirements and so it would need to wait for a new question. For now, what if anything should I do about manual draws for the Main tab?
But instead it auto populated older draws in below pictureOne thing I'm fixing is that the sheet should clear each time you go there, and in your picture you should have clicked the OK button.
ASKER
can't do that and in any case that's a change of requirements and so it would need to wait for a new question.
But is it possible to assign the add one or more draw only for the 1 to 80 tab ?
If yes, then I can ask that in the new question.
you should have clicked the OK button.
I pressed cancel is because it was populating older dates after showing you the photo
I thought this was the latest workbook : 29242002Yes, it's the latest one I've published, but please wait until I publish the "a" version.
ASKER
But is it possible to assign the add one or more draw only for the 1 to 80 tab ?No, not without pretty much rewriting the code for the workbook which would be a very big job and one which at this point I'm not willing to do. How does it hurt you if we keep the process of adding the manual draws to the Main tab, since they also turn up in the 1 to 80 tab?
ASKER
How does it hurt you if we keep the process of adding the manual draws to the Main tab, since they also turn up in the 1 to 80 tab?
You said it will affect the Select Draws option, I did not understand that ?
ASKER
That means currently in the Main tab if I select draw period, it would filter for 4 full draws for the day.
But if I want to filter two draws in the Select draw period , how would that happen ?
ASKER
Are we clear now?
ASKER
I then explained the reason for that was that I assumed that 1 draw consisted of all the draws for a day,
Yes I got it now.
"draw" you mean just one record
yes one draw means one record ( example 10 am is one draw, if 10 am and 1pm is together called 2 draws)
you mean just one record and "that when you type "1" and you haven't previously added any draws that you would like to be shown the 10 AM draw".
yes that is what I thought .
Before I continue with this I need to be clearer about what your aim is. Would you ever want to add more than one day's worth of draws (4 draws)?
Your current code updates 4 draws per day when clicking the Add draws button in the Manual draw tab which I am happy with, but is it also possible to add 1 draw= 1record for manual entries and then do the update. ?
but is it also possible to add 1 draw= 1record for manual entries and then do the update. ?Are you saying that you want to have the option to do both? In other words 2 options: one where 1 draw would mean one day's worth of data and the other where 1 draw would mean one draw?
ASKER
Are you saying that you want to have the option to do both? In other words 2 options: one where 1 draw would mean one day's worth of data and the other where 1 draw would mean one draw?
Yes. Is that possible ?
ASKER
Okay, I've done extensive testing and the coloring cells and adding times and draws all seems to work properly. You can now add individual times without first adding the draws since the last draws were downloaded or manually added. If you've manually added 1 to 3 times and you click the By Day option button you will be told to finish the times for the draw.
I hope that's clear.
29242002b.xlsb
ASKER
The Manual draw tab is behaving correctly because you have added dialogue boxes, so that has helped.
But the Match column values are erratic as in below picture
Just checking with you, In the main tab ,does it matter which column or how many numbers I type in the Typed Numbers row and some cells kept blank.
When I typed the numbers between AD:AH the match column displayed erratic values,
But when I typed those same numbers 70 71 75 79 80 between Z:AD, the match column displayed the values correctly.
Do I have to always type from Z column for the Match values to display correctly ?
Do I have to always type from Z column for the Match values to display correctly ?Why would you not want to do that? For this question it's required.
ASKER
Why would you not want to do that?
Because I deleted the first five typed numbers(Z:AD) 1, 2,3 ,4, 5 only and left the numbers 70 71 75 79 80. (AE:AI) as is to observe the draw history for the past few weeks.
In below picture, the Radio button are not selectable in Office 365,
At the moment the Radio button works only for Excel 2016.
Could you kindly make the Radio button compatible with Office 365 as well.
I could not reproduce the problem with counting colors (my favorite). If you can reproduce it, please record the detailed steps that it takes to reproduce the problem.
29242002c.xlsb
ASKER
I went ahead and removed the option buttons and replaced them with shapes.
Good one don't need to worry about compatibility, in saying that I am on the excel 2016 computer.
I will be able to test out the C file on Laptop office 365 only in the evening.
I have not tested the C file on Excel 2016 yet, because your C file draws are only upto 26th June.
And I had updated the "B" file till 30th June.
Copying draws from Main tab in B file and Pasting them to C file in the Manual Draws tab
How to copy the draws from 26th June to 30th June that is sitting in the Main tab of the B file and paste it to your "C" file Manual draws tab , without disturbing the coding. ?
The Next lotto server update will be made available on Coming Monday only
Attached is the "b" file , where the Main tab is updated till 30th June.
29242002b30JuneNight.xlsb
How to copy the draws from 26th June to 30th June that is sitting in the Main tab of the B file and paste it to your "C" file Manual draws tab , without disturbing the coding. ?At the present time you can't'.
I see that once again I left some worksheets visible that should be hidden. To hide them, right click on the yellow tab and choose hide. They need to be hidden because if you accidentally changed something in them it would have bad effects.
ASKER
I left some worksheets visible that should be hidden
ok will hide them
At the present time you can't'.
What about the steps you were saying about make a copy of the tab in your few comments earlier.?
Steps.
Can I make a copy of the Main tab of the B file to a new workbook and then copy the draws from that new workbook to the Main tab of the C file, would that work ?
Would it allow me to insert 16 blank rows in the C file of the Main above 26th June and then pasting the draws from 27th June to 30th June into it. ?
- Right click on any tab
- Choose unhide
- Select either "Draws" or "Draws 1 to 80" then click OK
- Do the same for the other one
Then:
- Copy the new B file draws from the Main tab
- Right click on Main tab row 4 so that the whole row is selected
- Choose Insert Copied Cells
- Copy the new B file draws from the 1 to 80 tab
- Right click on 1 to 80 tab row 4 so that the whole row is selected
- Choose Insert Copied Cells
- Copy the new B file draws from the (previously hidden) Draws tab
- Right click on Draws tab row 1 so that the whole row is selected
- Choose Insert Copied Cells
- Copy the new B file draws from the (previously hidden) Draws 1 to 80 tab
- Right click on Draws 1 to 80 tab row 1 so that the whole row is selected
- Choose Insert Copied Cells
- Hide the "Draws" and "Draws 1 to 80" tabs
- Cross your fingers
ASKER
- Copied the B file draws 1 to 20 (27th to 30th June) from Main tab.
- Right clicked on Main tab row 4 to select whole row.
- Chose Insert Copied Cells.
- Now this is where I got stuck is because it came up with a message in below picture
- Not sure what to do here?
ASKER
Meanwhile I entered the whole set of draws manually from 27June to 1July 22.
In below picture you can see number 80 in the main tab for the draw period
But in the 1 to 80 tab, the number 80 is completely missing in the 80 column in below picture (there should eight of the number 80 , but it is reading zero.
- Start again
- Copy the new B file rows from the Main tab and paste them in the Manual Draws tab of the C workbook
- Manually change the Draw numbers
- Click Add Draws
ASKER
Error in 1 to 80 tab
In 1 to 80 tab, Numbers 79 and 80 are missing for the selected draw period
In the Main tab however the numbers 79 and 80 are displaying correctly.
1 to 80 tab picture below (79 and 80 missing)
Missed numbers occur before selection of draw period
29242002d.xlsb
ASKER
Match column missing values
1pm, 3pm, 6pm are correctly displaying Match values, but not 10 am.
After selecting time for 10 am, the Match column is missing values in below picture
ASKER
So I tried it again but same problem.
Could you kindly cross check my uploaded file.
Uploaded file with 10 am filter not showing match values. 29242002dSavedfor3rd July.xlsb
In any case I found that manually adding draws does not work properly if the Main tab is filtered by draw and/or time. I corrected that by requiring that the tab be unfiltered before continuing.
29242002e.xlsb
ASKER
Following steps was the reason for 10 am missing the match column values.
1) Updated draws till 3rd July
(file name :93af90dc-fb15-11ec-9f8d-46ad7aa71c47.xlsx)
2) Clicked Select draws button and Selected 3rd July to 28th June.
3) Then Selected 10 am draw for draw times and the match column showed values correctly
4) Now at this point, I changed the values in Typed numbers to 1,2,3,4,5 (Z:AD)
5) The moment I did that the match column values disappeared.
That means I cannot change the Typed numbers after filtering the times.
But if I change the typed numbers before Time filter , the match values work correctly.
Could you kindly remove the above message.
I am sure, I will remember to unfilter the Main draw tab of Draws and Times
29242002f.xlsb
ASKER
Just the last part of this question was regarding Keyboard shortcut for Zoom in /out . My laptop is 11.5 inch, so have to constantly zoom in and out for the 1 to 80 tab. If you could kindly create a vba code for the Keyboard shortcut.
I tried the one from your link, Ctrl + Alt + "+" shortcut does not work for excel 2016.
ASKER
ASKER
ASKER
Whatever that percent is, why not set that as the zoom for the sheet and be done with it? I remember seeing it larger and I set it back to 100% for my convenience, but I'll avoid doing that in the future.
ASKER
However when I use the desktop computer I do not need the zoom, because the monitor is large size.
Or is there an option to set and forget , till l need to change it again ?
ASKER
Or I could add a button above Date and Time that says 150%. When clicked it would toggle between 150% and 100%.
or I could go for your button option
Or is there an option to set and forget , till l need to change it again ?Yes, literally, just set it and forget it.
ASKER
ASKER
how do I set and forget steps ?
- View pane->Zoom icon
- Pick one of the listed percents or enter a different percentage in the Custom box.
ASKER
ASKER
ASKER
ASKER
ASKER
ASKER
I am posting a new question for Ranking