Cancelado

Modify Existing Free Microsoft Excel Spreadsheet

Hi I have a free lottery spreadsheet I previously downloaded. The original source webpage information is included in the zip file.

I'd like to customize this lottery spreadsheet to tally number combination pairs, starting from the previous week's 1st number & successively matching it up with all the winning numbers drawn next week (rather than just matching pairs in the same drawing/row)

Modelled off the main spreadsheet by keeping its macro formatting which is excellent, but have the first number (of the matched pair) being from week 1 and the second number being from week 2 then successively match all week 1's first number to all 6 of week 2's numbers. And then go the second number drawn in week 1 and repeat through all 6 of week 2's numbers etc.

eg week 1 numbers: 3,5,14,22,30,44 week 2 numbers: 6,12,15,16,31,44 in the pairs sheet it would start matching up pairs 3,6 3,12 3,15 ...3,44 then 5,6 5,12 5,15 ...5,44 etc all the way to 44,6 44,12 44,15 ...44,44 (therefore the same number can pair up with itself (eg 44,44) as it's spread accross 2 weeks. And the bottom half of the matrix would also be used rather than blank)

It probably needs the code modified or a new macro recorded to do the above request. The original webpage has instructions on the source macro and vba code.

If the above can be achieved with the sample 20 rows of data in the spreadsheet, I'd like to at a later date paste lot's more rows of data than just 20 in the original file. In the original file, I pasted in extra rows of data, and the macro seemed to handle the request and tallied all the numbers. Also the ability to add more than 6 balls.

Thanks

Habilidades: PHP

Ver mais: starting with visual basic, microsoft number, microsoft excel spreadsheet free, microsoft excel spread sheet, microsoft excel spreadsheet, 3 d free, microsoft vba, microsoft macro, microsoft excel VBA, vba excel macro, vba code excel, tally a, spreadsheet microsoft excel, row spreadsheet, excel to tally, Excel Macro VBA, Excel Formatting, Excel and VBA, excel $2-30, d matrix, excel macro combination, modify existing source code, tally data sheet, spread sheet formatting, excel sheet formatting

Acerca do Empregador:
( 6 comentários ) Australia

ID do Projeto: #3041197

7 freelancers estão ofertando em média $31 para este trabalho

vserv

See private message.

$12.75 USD in 14 dias
(99 Comentários)
6.0
DenisSmolentsev

See private message.

$42.5 USD in 14 dias
(88 Comentários)
5.2
syedmahtab

See private message.

$38.25 USD in 14 dias
(36 Comentários)
4.7
ALinh

See private message.

$29.75 USD in 14 dias
(25 Comentários)
4.1
haseebhm

See private message.

$34 USD in 14 dias
(20 Comentários)
3.8
orisoftware

See private message.

$15.3 USD in 14 dias
(0 Comentários)
0.0
NICRAD

See private message.

$42.5 USD in 14 dias
(0 Comentários)
0.9