Em Andamento

excel and vba programming

I have a finance spreadsheet that feeds manually form the banking account. Each record is them cathegorised in many criterias which ultimately forces me to split an entry into multiple entries each with its own combination of categories. This has led to a massive denormalized table that's hard to process and work with.

Now I want help to split this table into a master table (with only the bank records) and a details table (containing all the splitted cathegorised records) . I want to automate the navigation from one view to the other (kind of "Edit record details..."). Both views must be editable in excell spreadsheet view

Habilidades: Excel, Visual Basic, Visual Basic para Apps

Veja mais: excel vba programming mumbai, excel vba programming bid, excel vba programming hourly rates, excel vba programming rate hourly, excel vba programming stopwatch macro, outsource excel vba programming, excel vba programming hire, excel vba programming cheque, excel vba programming outsourcing, excel vba programming tampa, book excel vba programming, excel and excel vba programming for beginners, excel vba programming for dummies, excel vba programming for dummies 4th edition, excel vba programming for dummies pdf, excel vba programming free addins, excel vba programming freelancer india, excel vba programming hour rate

Acerca do Empregador:
( 0 comentários ) Lisboa, Portugal

ID do Projeto: #23395139

Concedido a:

nvchien94

Hello there, I am an Excel expert and I can do automate macro for you to split your bank transaction. I think it will take 3 days to complete and we can start now. Please send me a message, we can start with sample fil Mais

€264 EUR em 3 dias
(171 Comentários)
6.2

57 freelancers estão ofertando em média €422 para esse trabalho

schoudhary1553

Hello, I can help you in excel VBA project. I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. Fo Mais

€750 EUR in 7 dias
(340 Comentários)
8.0
asin1987

Dear Employer, I understand that you need to normalize a data set automatically which you are doing right now manually and then link it to different data sets. Please share the sheet and let me know the exact details. Mais

€300 EUR in 3 dias
(191 Comentários)
7.7
Eagles90

Dear Client, I am an experienced VBA and Excel professional and have served the clients throughout the globe. Please review my profile to get an insight into the quality of my services. I am the one who believes in l Mais

€500 EUR in 2 dias
(148 Comentários)
7.9
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel macro that will manipulate your data (normalize it). I plan to use a com Mais

€300 EUR in 2 dias
(250 Comentários)
7.5
dgled

Hi, I already built some modules for accounting. The modules enable to type actual/forecast transactions in one sheet or to upload external files (like CSV files from banks). At the end of the process, the module produ Mais

€500 EUR in 7 dias
(89 Comentários)
7.1
prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can help you to split your table into a master table (with only the bank records) and a details table (containing all the splitted cathegorised records). please pin Mais

€500 EUR in 14 dias
(375 Comentários)
7.2
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 260 projects successfully completed here. I can automate what you need and display the information Mais

€285 EUR in 3 dias
(242 Comentários)
7.0
wsh2

At your earliest convenience, please attach a sample of your financial model to this private chat message thread so we may better discuss your requirement. Many thanks in advance! Greetings Portugal from the USA.. {sm Mais

€500 EUR in 7 dias
(52 Comentários)
6.4
dvcontact

Hi, Would you like to see a quick demo of your masters table and details table formed from your records before you award the project? You can consider it professionally done. Rather than fill this proposal with a list Mais

€500 EUR in 5 dias
(53 Comentários)
6.4
seoguru17

I am good at Excel formula and VBA/Macro, I need to see the data so I can understand your requirement, I have a few question to discuss so I need you to send a message on chat.

€500 EUR in 7 dias
(80 Comentários)
6.3
rashedkhanrubel

Hi, I have read the project requirement & interested to work for this project. Please send a message so we can discuss more & start the project. Thanks.

€250 EUR em 1 dia
(111 Comentários)
5.6
bizwizz

I think I am a good fit for this project job because I have all the qualities that you are looking for. Experience is the golden factor with this type of project and I have a minimum of 9+ years of working experience i Mais

€600 EUR in 5 dias
(21 Comentários)
5.8
zu02

Hello I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VBA. I'm ready to discuss for better solution directly in Excel or via Ms Access app with Excel automation. I'm profession Mais

€500 EUR in 7 dias
(33 Comentários)
5.8
vsprybhanu

Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of splitting or consolidating excel data and Creating Mais

€250 EUR in 3 dias
(90 Comentários)
5.7
beltran0404

Hello, I am Luis and I will be glad to assist you with your project. I have experience with Excel and Visual Basic. I can help you to upgrade your current Excel tool to the next level. Please contact me by chat then Mais

€300 EUR in 10 dias
(128 Comentários)
5.6
AnowarRatul

€ 250 Only ------- BBA, MBA in Accounting & Finance ------ Excel VBA Macro Coding, Formula Generation and Automation Process Expert with 5* Ratting ------ I can make you a VBA program which will make your data categori Mais

€250 EUR em 1 dia
(81 Comentários)
5.0
Sercho56

Hello, I am an Australian-based software developer with significant experience in developing custom Financial Solutions in VBA. I have built my own automated workbooks for managing Share Portfolio, Bank Accounts and In Mais

€333 EUR in 5 dias
(15 Comentários)
4.7
paulodayto08

Hi Good Day! Please let me help you to complete this work. I am from Philippines and we experienced a volcanic eruption last weekend please help us through this work. Please consider my bid. I am a Project Management Mais

€300 EUR in 4 dias
(37 Comentários)
4.5
nblsoft

Hi sir, I am interested in your project and offer my services. I am skilled in Excel, VBA, database designing and software development. I can give you best solution within budget and timeline. Looking forward.

€500 EUR in 7 dias
(7 Comentários)
4.3
MonisZafar

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this due to my experience with VBA and Excel. It will be quick and accurate. If interested, we can discuss this further Mais

€250 EUR em 1 dia
(9 Comentários)
3.8