Đã Hủy

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

Kỹ năng: Excel, Visual Basic

Xem thêm: vba excel dynamically create form, excel vba dynamic form, excel vba create chart display data, excel vba create dynamic form, vba create form excel, excel vba error form, excel vba create reference, excel vba chart show data table, excel vba create classes dynamically, excel vba input form, excel vba create expense report, excel vba create data file, excel vba create xml file, excel vba create xml document, excel vba create xml, excel vba create menubar

Về Bên Thuê:
( 50 nhận xét ) Arlesey, United Kingdom

Mã Dự Án: #14846698

53 freelancer đang chào giá trung bình £69 cho công việc này

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

£60 GBP trong 1 ngày
(61 Đánh Giá)
0.0
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 Thêm

£80 GBP trong 10 ngày
(117 Đánh Giá)
0.0
techlogix3

Hi, I have got Rich experience in Joomla, Wordpress, Codeigniter, Cake PHP), .NET, Asp.NET, Vb.NET, HTML 5 etc.& mobile apps Relevant Skills and Experience Also have very good knowledge of javascript, jQuery Json, Thêm

£76 GBP trong 10 ngày
(0 Đánh Giá)
0.0
£88 GBP trong 0 ngày
(254 Đánh Giá)
0.0
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 Thêm

£40 GBP trong 1 ngày
(97 Đánh Giá)
0.0
PriyankaGuha1

I have around 7years of experience in MS Excel/VBA/Web Searching/Web Scrapping/Data Analysis.I am dedicated and hardworking. I stick to delivery timelines and I am committed to my work.I believe this sets me aside from Thêm

£49 GBP trong 3 ngày
(1 Đánh Giá)
0.0
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

£72 GBP trong 10 ngày
(23 Đánh Giá)
0.0
£90 GBP trong 5 ngày
(14 Đánh Giá)
0.0
ugolopez

Working experience on Excel & VBA since 2005, certified on Excel since version 2003, I can easily create what requested within 1 day Relevant Skills and Experience Excel 2003/2016, VBA Proposed Milestones £90 GBP - E Thêm

£90 GBP trong 10 ngày
(0 Đánh Giá)
0.0
saisrikanth1993

A proposal has not yet been provided

£79 GBP trong 12 ngày
(0 Đánh Giá)
0.0
richardnguyen46

--Very Nice Job. Professional VBA & Excel expert. Best result in time----- Relevant Skills and Experience VBA & Excel Proposed Milestones £40 GBP - full No problem

£40 GBP trong 1 ngày
(4 Đánh Giá)
0.0
inelsonventura

a Habilidades y experiencia relevante a Htos propuestos £72 GBP - d que necesitas

£72 GBP trong 10 ngày
(0 Đánh Giá)
0.0
£50 GBP trong 3 ngày
(1 Đánh Giá)
0.0
sumankunduit

Hi I have more than 5 years experience in Excel macro and VBA.I can do the work within 2 days in a cheap cost Relevant Skills and Experience 5 years experience in Excel Macro, VBA Proposed Milestones £50 GBP - Final Thêm

£50 GBP trong 3 ngày
(0 Đánh Giá)
0.0
pergatcheema

A proposal has not yet been provided

£50 GBP trong 5 ngày
(0 Đánh Giá)
0.0
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 Thêm

£80 GBP trong 10 ngày
(61 Đánh Giá)
0.0
gillani07

I have done similar jobs in past. See my portfolio. I can work at 9Euro/hr. Relevant Skills and Experience Excell Macros, SQL data bases, Python Proposed Milestones £72 GBP - As per your requirements

£72 GBP trong 10 ngày
(0 Đánh Giá)
0.0
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 Thêm

£80 GBP trong 10 ngày
(168 Đánh Giá)
0.0
£44 GBP trong 10 ngày
(0 Đánh Giá)
0.0
insidenetsoft

Hi John, I worked before with vba and vb6 forms, I have recurrent customers from usa and I would love to connect and help you with this data management tool. Your requirement is clear, just let me know when can we s Thêm

£40 GBP trong 2 ngày
(13 Đánh Giá)
0.0