Em Andamento

MS Excel (Macro)

Hello Freelancers!

Create three grid boxes (refer to attached example)

Each grid box must contain 6 cells from left to right and 40 cell from top to bottom.

GRID BOX 1

In the 1st cell of grid box #1 select an ODD # between 1 and 8

In the 2nd cell of grid box #1 select an EVEN # between 8 and 17

In the 3rd cell of grid box #1 select an ODD # ># in cell 2 but <= 26

In the 4th cell of grid box #1 select an EVEN # ># in cell 3 but <= 29 and no more than 3#’s away from # in cell 3

In the 5th cell of grid box #1 select an ODD # between last # in cell 4 and 40

In the 6th cell of grid box #1 select an EVEN # > # of cell 5 and < 45

GRID BOX 2

In the 1st cell of grid box #2 select a # between 9 and 17 – ensure it is not a duplicate of any number in the cells of grid box #1

In the 2nd cell of grid box #2 select # between 18 and 26 – ensure it is not a duplicate of any number in the cells of grid box #1

In the 3rd cell of grid box #2 select # which is half way between the number in cell 2 and 34 – ensure it is not a duplicate of any number in the cells of grid box #1

In the 4th cell of grid box #2 select # > # in cell 3 and < 36 – ensure it is not a duplicate of any number in the cells of grid box #1

In the 5th cell of grid box #2 select an EVEN # > # in cell 4 and < 43 – ensure it is not a duplicate of any number in the cells of grid box #1

In the 6th cell of grid box #2 select an ODD # > 43 – ensure it is not a duplicate of any number in the cells of grid box #1

GRID BOX 3

In the 1st cell of grid box #3 select an EVEN # between 1 and 8 - ensure it is not a duplicate of any number in the cells of grid box #1 and grid box #2

In the 2nd cell of grid box #3 select an ODD # > # in cell 1 and < 26 - ensure it is not a duplicate of any number in the cells of grid box #1 and grid box #2

In the 3rd cell of grid box #3 select an ODD # ># in cell 2 but < 36 - ensure it is not a duplicate of any number in the cells of grid box #1 and grid box #2

In the 4th cell of grid box #3 select an EVEN # ># in cell 3, but no more than 3#’s away from # in cell 3 - ensure it is not a duplicate of any number in the cells of grid box #1 and grid box #2

In the 5th cell of grid box #3 select an EVEN # between last # in cell 4 and 42

In the 6th cell of grid box #3 select an ODD # > # of cell 5 and < 45

In each grid box fill the cells below the selected number in ascending order until number 45 and then start with number 1 again (see example of attached excel spreadsheet)

Create 4 sets of the three grid boxes for each of the odd numbers left of box #1

Start your bid with "TT" so that I have an idea that you guys have read the project details.

Regards,

MJ

Habilidades: Excel, Microsoft

Ver mais: microsoft excel spreadsheet, microsoft excel freelancers, macro freelancers, freelancers with number, microsoft macro, spreadsheet microsoft excel, excel duplicate, excel 2014 macro, excel project idea, microsoft excel macro, excel create macro, excel spreadsheet grid box, create macro, macro read excel, microsoft project excel macro, convert microsoft excel spreadsheet apple numbers, convert excel spreadsheet apple numbers format, convert excel spreadsheet apple numbers, read microsoft project, refer attached spreadsheet details, odd excel, duplicate excel, bid comparison excel spreadsheet, excel macro project, bid excel macro

Acerca do Empregador:
( 4 comentários ) Clarkson, Perth, Australia

ID do Projeto: #6807676

Premiar a:

MKL7

TT Dear, This is an easy macro with some (random) numeric and conditional functions that I can create very quickly. The only question I have is one about the design / output: where do you want the four sets to Mais

$30 AUD em 3 dias
(12 Avaliações)
2.6

38 freelancers estão ofertando em média $105 para este trabalho

Teloquence

TT - Hello, I am top freelancer on this forum with 200+ five star reviews and with a completion rate of 90%. I have understood your requirement and I am sure I can implement this. Check my past reviews for your referen Mais

$100 AUD in 0 dias
(232 Comentários)
7.0
zExcel

TT ....................................................................................................................................................................................................................

$180 AUD in 2 dias
(120 Comentários)
6.6
deepbluetech

TT Hi MJ, The attached example file does to comply to the description of each grid boxes. So, I suppose they are for representation purpose only. And, the sequences are to be selected randomly and meeting the crit Mais

$150 AUD in 3 dias
(155 Comentários)
6.4
avinav606lx

TT Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. Mais

$54 AUD in 0 dias
(79 Comentários)
5.9
dpune

TT Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 215 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your posi Mais

$200 AUD in 7 dias
(56 Comentários)
5.5
aarifakhtar

"TT", Hi: I have few questions: When you say, select number between x and y. Do you include x and y? You have written "Create 4 sets of the three grid boxes for each of the odd numbers left of box #1". In the example s Mais

$166 AUD in 5 dias
(38 Comentários)
5.3
vikas0903

Hi, I am working as Lead Pricing Analyst in a Fortune 500 MNC. I have worked on pricing models, income statements, value-pricing projects etc. Prior that I have completed MBA and bachelors in Engineering. I h Mais

$155 AUD em 1 dia
(25 Comentários)
5.2
ethicalboy

TT Hello MJ, I checked what you wrote but have some ambiguity regarding the last lines, generally it seems a straightforward project for me that worked on random number generators, have good statistics and mathematics Mais

$59 AUD in 4 dias
(60 Comentários)
5.2
expertatwork

TT....hey MJ, we can do this, please reply, we can discuss further, thank you !

$48 AUD in 2 dias
(79 Comentários)
5.2
kher78

TT Hello, You've done a great job explaining what you're looking at trying to get done. The only real question I have is whether you'd want a message box to appear if one of the checks returns a condition that i Mais

$95 AUD in 3 dias
(53 Comentários)
5.0
dragos1910d

Propunerea nu a fost încă furnizată

$100 AUD in 3 dias
(44 Comentários)
4.9
abdellatif81

A proposal has not yet been provided

$111 AUD in 2 dias
(10 Comentários)
4.9
sajidmahmud

"TT" Dear sir I see your project and i do it as your acceptation. I have 3 years experience to work in a any kind data process Web Scraping, Web Search, Excel,SEO and Photoshop work would like to assure you that I Mais

$155 AUD in 3 dias
(78 Comentários)
4.7
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your pr Mais

$40 AUD in 6 dias
(27 Comentários)
4.5
treshakhanom

"TT" Dear Sir, I am extremely interested to your project and ready to start immediately. Sir if you give me chance I can do this job.

$111 AUD in 3 dias
(18 Comentários)
4.2
JeffLee21

Dear Sir, I'm quite interested by your project. I am programmer with sincere and capable. I have developed many project. You can found good my projects in my work history. Particular, I have rich experie Mais

$54 AUD em 1 dia
(4 Comentários)
3.6
excel4engineers

I will provide you VBA macro script which will populates the three grids with one click. You can get it with in one day. You can get different values each time you press go.

$30 AUD em 1 dia
(9 Comentários)
3.5
zebracaro

i can do it for you quickly and exactly with VBA .

$155 AUD in 3 dias
(7 Comentários)
3.2
MasterExcel

I am Data Entry, MS Word and MS Excel Expert. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high Mais

$30 AUD in 3 dias
(11 Comentários)
3.2
prabakarm23

Greetings for the Day!!! i have 5 years of experience in Excel macro, VB script and VB application creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server Mais

$83 AUD em 1 dia
(6 Comentários)
2.6