Em Andamento

Modify Existing Free Microsoft Excel Spreadsheet (for vserv)

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.


Habilidades: PHP

Ver mais: microsoft number, microsoft excel spreadsheet free, microsoft excel spread sheet, microsoft excel spreadsheet, 3 d free, 2 d drawing, microsoft vba, microsoft macro, microsoft excel VBA, vserv, vba code excel, tally a, spreadsheet microsoft excel, row spreadsheet, excel to tally, Excel and VBA, d matrix, excel macro combination, modify existing source code, tally data sheet, spread sheet formatting, excel sheet formatting, spreadsheet vba code, excel macro add, excel macro match data

Acerca do Empregador:
( 6 comentários ) Australia

ID do Projeto: #3044859

Premiar a:


See private message.

$12 USD em 14 dias
(17 Avaliações)