Optimize Excel File with 5Sheets Entry Mask, Calculation file, 2 Output files, Supporting file
Budget: €30 – €250 EUR
I am looking for someone to help me with a project, involving the creation of an Excel file with a specific layout and the use of Visual Basic for Applications (VBA) to automate tasks. I would need this Excel file to perform financial calculations. Utilizing VBA would help automate the calculations, making the data entry more efficient and reliable. I already have a specific layout for my Excel file and I have made a version but when running it sometimes the Macro jobs give out error message but not always. I need to run 3 macros, one of them I have to open to run it (the other two in the excel sheet through Buttons). Not ideal. On top in the output file I have a little layout adjustment to perform which I need to do manually at the moment as the macro doesn’t exactly perform what I need. I am open to suggestions if the freelancer believes it would make the project/program run more smoothly or accurately. Whoever accepts this task should have a thorough understanding of spreadsheet programs as well as VBA. I'm looking forward to hearing from a talented freelancer who can take on this project.
4 Sheets
1. Entry Mask Sheet (already there) but optimisation requested (this file also has to Macro Buttons)
2. Cost Sheet (purchasing rates) (already there) - shows actual cost and does simply cost
3. Output Sheet (Sell rates) (alread there but optimisation) based on entries in 1 and 2 it gives out sales rates of countries & services selected in 1. as well as macros run from 1 make automatic formatting (but there are inefficiencies)
4. Output Sheet (shall show margins in % and absolute) Sell versus purchasing but in format of Output Sheet (Sell rate) - not there yet.
Few bugs:
1.. When running Visual Basic (job2) for the formatting of the Output sheet it only copies EURO from the source sheet (Cost file/purchasing file) not the other needed currencies CHF, DKK, GBP, NOK, PLN
2. When running Visual Basic (job3) Button in sheet Entry Mask it shall format the cells the Output Sheet but only those that are filled from job 1 - job2, Problem: it also does formatting of cells not filled. Therefore manual removal is needed.
3. Three Macro jobs - ideally to be done with one button/one click
Result:
Create Output sheet (selling rates)
Create Margin sheet (Margin absolut & %)
File & high level documentation will be provided.
4 Sheets
1. Entry Mask Sheet (already there) but optimisation requested (this file also has to Macro Buttons)
2. Cost Sheet (purchasing rates) (already there) - shows actual cost and does simply cost
3. Output Sheet (Sell rates) (alread there but optimisation) based on entries in 1 and 2 it gives out sales rates of countries & services selected in 1. as well as macros run from 1 make automatic formatting (but there are inefficiencies)
4. Output Sheet (shall show margins in % and absolute) Sell versus purchasing but in format of Output Sheet (Sell rate) - not there yet.
Few bugs:
1.. When running Visual Basic (job2) for the formatting of the Output sheet it only copies EURO from the source sheet (Cost file/purchasing file) not the other needed currencies CHF, DKK, GBP, NOK, PLN
2. When running Visual Basic (job3) Button in sheet Entry Mask it shall format the cells the Output Sheet but only those that are filled from job 1 - job2, Problem: it also does formatting of cells not filled. Therefore manual removal is needed.
3. Three Macro jobs - ideally to be done with one button/one click
Result:
Create Output sheet (selling rates)
Create Margin sheet (Margin absolut & %)
File & high level documentation will be provided.