Excel form query to populate only certain columns in larger table in another document

[faodavid]

I have a Contracting document which has a dynamic table with approx 60 columns. The document is currently used by two people using sharepoint - when using this document locally functionality is fine, when using online excel functionality is poor. I want to create an excel form that will populate 18 or so of the columns with unique data in the contracting document and use vlookup to populate the remainder of the contracting document, thus reducing the need to actually be in the contracting document in order to create new rows of information. Can anyone help?

Thanks

dave

[PFDave]

Hi Dave,

Can you provide a sample workbook so we can create a working document you can use.

[faodavid]

Thanks I'll do that now, back shortly

[faodavid]

Hi
Please see attached example work book what I want to achieve is as follows
I want to create an Excel Form using the header info on the tab marked UNIQUE INFO FOR FORM whereby the info entered on the form is selected via drop down options ( I have included these drop downs (where required) on the tab so you know what the options are.

Once the form is completed I want it to add a new row to the external doc (I have called this CONTRACT TABLE IN OTHER WORKBK) - the form should populate just the header fields marked in black on the CONTRACT TAB, the rest of the fields would then autopopulate via vlook up based on artist name and venue

The contract doc will live on sharepoint the form I would like to store locally thus not requiring to access the sharepoint contract when needing to populate or edit it

Hope that makes sense

Dave

[faodavid]

Doh How do add the attachment?

[PFDave]

Go advance, manage attachments, browse, upload file

[faodavid]

Thanks
Hopefully this has attached the doc

[faodavid]

Hi dave
Did you have any luck with this?
Dave

[PFDave]

Hi dave
Did you have any luck with this?
Dave

Hi, I've just come on to take a look but I can't open the file for some reason.

Could you try to upload again, otherwise I'll have to spend some time making a rough template we can look at tweaking.

[faodavid]

Hi Dave
Does this work?
dave

[PFDave]

Hi Dave
Does this work?
dave

Nope, not sure why as I can open some files on here and others I can't.

So if I'm understand correctly, you want the user to input detail for 18 of the fields by method of a userform, then the remaining columns are updated by a vlookup to another document which will hold the required detail.

Is that about right?

[faodavid]

Yes thats correct - I could email you the sheet?

[faodavid]

Yes thats correct - I could email you the sheet?

The user form would need to have some drop downs too