Kapalı

Excel VBA - Create Form based on Table

HI,

In need of this project being completed quickly please.

What I need is some VBA to either create a form or populate a sheet based on a dynamic table which changes.

The idea is when I update the table I run the macro which create the form or populates a sheet.

The goal is to create a transfer log were by the user chooses a number for the product being transfered (multiple items) this then creates a total in a coloumn. The user then presses the submit button which moves the data into a table in another sheet and clears the sheet or form for next transfer.

Attached is a demo workbook.

Sheet - Location-1 has a demo of what I'm looking for based on a sheet population.

Sheet - App Sync Data has the table which changes.

When you open to workbook you need to click on Admin button and password is foo to view all pages.

Thanks,

John

Beceriler: Excel, Visual Basic

Daha fazlasını görün: excel vba dynamic form, vba create form excel, excel vba error form, excel vba create reference, excel vba input form, excel vba create xml, excel vba create menubar

İşveren Hakkında:
( 48 değerlendirme ) Arlesey, United Kingdom

Proje NO: #14846698

54 freelancer bu iş için ortalamada 68£ teklif veriyor

cgullapalli

Hi John, I have gone through the requirement. I would like to discuss few points, that i felt missing connectivity regarding the table. Looking forward to work on this project. Relevant Skills and Experience Excel vb Daha fazlası

1 gün içinde 90£ GBP
(514 Değerlendirme)
7.5
in 0 gün içinde88£ GBP
(254 Değerlendirme)
7.6
schoudhary1553

Greetings johnhoube, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have the 5 years Daha fazlası

1 gün içinde 90£ GBP
(182 Değerlendirme)
6.9
cugamelover

I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, and output in Excel using VBA. Relevant Skills and Experien Daha fazlası

in 10 gün içinde80£ GBP
(166 Değerlendirme)
7.0
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Habilidades y experiencia re Daha fazlası

in 3 gün içinde80£ GBP
(172 Değerlendirme)
6.7
chriskerpini

Write VBA script to fill-in a form or sheet based on a dynamic table. Duration 2 days max Relevant Skills and Experience I have 16+ years experience working with Excel/VBA and 13 years teaching them both (all level Daha fazlası

in 10 gün içinde80£ GBP
(61 Değerlendirme)
6.3
paris2785

I've read your brief and can see that you'd like to have an Excel spreadsheet. Relevant Skills and Experience I have 7 years experience in designing and developing Excel spreadsheets filled with formulas and VBA c Daha fazlası

in 10 gün içinde80£ GBP
(115 Değerlendirme)
6.4
srinichal

I look forward to discuss further details Relevant Skills and Experience proven expertise on this site Proposed Milestones £88 GBP - milestone

in 10 gün içinde88£ GBP
(49 Değerlendirme)
6.0
dpune

create macro which builds form based on user input Relevant Skills and Experience Excel/VBA Proposed Milestones £80 GBP - Completed macro Hello, I Have more than 14 years of exp. Completed 320+ projects. Look at my Daha fazlası

in 5 gün içinde80£ GBP
(115 Değerlendirme)
6.3
1 gün içinde 72£ GBP
(191 Değerlendirme)
6.1
ksriniravi

I can develop the macro to transfer data to another sheet as per requirement for GBP 40. Relevant Skills and Experience 18 years experience in using Excel as part of daily work life. In the process, implemented lot of Daha fazlası

1 gün içinde 40£ GBP
(85 Değerlendirme)
6.0
nagyzoltan68

Hello, I would like to work on your project. I have great experience using excel macros / vba, userforms. I have had many similar work before, estimated delivery time: 24 hour. Thank you. Regards. Relevant Skills an Daha fazlası

1 gün içinde 60£ GBP
(83 Değerlendirme)
5.7
MohsanEijaz

I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Relevant Skills and Experience VBA Proposed Milestones £72 GBP - d

1 gün içinde 60£ GBP
(56 Değerlendirme)
5.6
axiomswb

We have expertise in excel VBA, web scraping, data processing,data entry. Client satisfaction is our main motto for long term relationship.

1 gün içinde 49£ GBP
(31 Değerlendirme)
5.4
zu02

Hi, I've viewed your Transfers Log vDEVELOPMENT.xlsm. Your current task should to make using SQL/ADO vba coding, I'll code faster. Relevant Skills and Experience SQL, ADO, VBA Proposed Milestones £72 GBP - default

in 10 gün içinde72£ GBP
(22 Değerlendirme)
5.5
in 5 gün içinde90£ GBP
(14 Değerlendirme)
5.0
abhinovpankaj

Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat Daha fazlası

in 10 gün içinde72£ GBP
(43 Değerlendirme)
5.2
sonarkaushik

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. Daha fazlası

in 2 gün içinde78£ GBP
(42 Değerlendirme)
5.6
The24CarrotsInc

Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME Deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc Relevant Skills an Daha fazlası

in 10 gün içinde40£ GBP
(35 Değerlendirme)
4.7
awaisjahangir25

I can work on it brother. Do let me know over chat. I've really good experience of working on Visual Basic in Excel .

1 gün içinde 90£ GBP
(12 Değerlendirme)
4.1