Transfer data from one form to another.

**Pojzon** · 03-10-2018, 06:27 AM

Hello, I've got something like this:
example.jpg

I would like to transfer data from left part of picture into right part format. Name is always first and under it are listed tasks, amount of tasks is never the same. I can export Name and Date manually no problem, I just need some automation with transfering correct tasks. Any amount of help columns is welcome. I would prefer non VBA solution if possible. Thank you for any help.
Crossposted my problem at: https://www.mrexcel.com/forum/excel-...ml#post5023857

**Pojzon** · 03-10-2018, 04:04 PM

Is this even possible?

**JohnTopley** · 03-11-2018, 05:26 AM

Try

Please Login or Register  to view this content.

**Pojzon** · 03-11-2018, 02:30 PM

Nice, looks great, thank you very much for this. Could you just please tell me which part of the code should I change if I need more columns with date than 5? I can't figure this out.

**JohnTopley** · 03-11-2018, 02:34 PM

Please Login or Register  to view this content.

UNTESTED!

Post a sample file.

**JohnTopley** · 03-11-2018, 03:06 PM

Updated code

Please Login or Register  to view this content.

Change value of "Ndates" (Highlighted)

**Pojzon** · 03-12-2018, 11:13 AM

Thank you very much!

Transfer data from one form to another.

LinkBack

Thread Tools

Rate This Thread

Display

Transfer data from one form to another.

Re: Transfer data from one form to another.

Re: Transfer data from one form to another.

Re: Transfer data from one form to another.

Re: Transfer data from one form to another.

Re: Transfer data from one form to another.

Re: Transfer data from one form to another.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] transfer data from form to form

Transfer data from record in continuous form to popup form?

Using VBA to transfer data from Excel form to a web form. error 'Permission Denied'

Search form and transfer data

Transfer User form data to a worksheet w.r.t. combobox item on the form

[SOLVED] Transfer data to form from Excel range upon loading of form.

[SOLVED] Form 2 Form data transfer

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions