=replace formula ever changing data

[marz4now]

Hi my name is Chris and thanks for taking the time to read this post. I have a lottery pool spreadsheet im working on for work. On the right side of work book i have the lotto drawn numbers for wednesday and saturday that i will input as they come out.(located in cells ac.3 to ap.53) was wondering if there is a way to copy numbers i enter to the boxes located O.21 TO T.22 or the graphic of lotto balls below in there text box. The work book shows both ways with graphic for saturday and no graphic for wednesday. once you see workbook you will understand more clearly. thanks in advance for any help.

lotto2-with-data1.xlsx

[marz4now]

index maybe? I don't know have spent 8 hrs on it.

[marz4now]

forget the lotto balls thats probably vpn. how about formula to replace cells (boxes) with new data from wednesday list and saturday list forgeting data from before. if you have any questions after looking at workbook let me know.

[canapone]

Hi,

in O21 to be copied to the right (Wednesday's numbers)

=LOOKUP(2,1/(AC3:AC53),AC3:AC53)

-----------------

(Saturdays numbers) same formula :

=LOOKUP(2,1/(AK3:AK53),AK3:AK53)

you could copy the formulas below the lotto balls and adjust "transparency" format.


Cheers

[Loganeb]

Hello,

Click on the textbox, and delete the current value. In the formula bar, you can put a lookup value, and the textbox will reflect whatever value you look up. For example, a simple way to test this would be to delete the 37 in the first lotto ball, then in the formula bar type =AK7 and the 37 will be pulled into the textbox. You can construct a lookup to reference the most recently populated row, or have it changed based on a date cell that someone could manipulate.

[canapone]

Hi,

please see the file attached: there are some formula read by lotto's balls in N34:R34.

Cheers

[marz4now]

canapone so i put lotto balls back on wednesday because of how wonderful your formula worked. However do to the fact that formula is located outside cells i cant recreate what you did. lotto.can.xlsx

[canapone]

Hi,

please see the attached file.

You could place the green formulas wherever it's good for the organization of your file (for istance: under the lotto's balls )

Then you have to adjust the references on Lotto's balls.

Hope it helps