General discussion


Excel problem

By Borg7of9 ·
I have an excel spreadsheet, with about 50 colums of user data. On a second workbook, I made a small report form, that will contain the information from one of the 50 colums.

I want to know how to automate having the form filled, with data from one of the fifty colums.

For example, if I need to print the data in colum 23, how do I tell the form to get the data from that colum?

I need to do this exactly this way, as the form also contains other data. Therefore I can not simply print the colum itself. Also I am only taking certain cells from the colum, into the report form.

Hope I made this clear!!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by JRod86 In reply to Excel problem

Haven't tried it yet, but the best way would be to do an import from the other workbook. You can automate it with a macro if you're not changed the cell selection.

If you are really ambitious, you can make the macro then edit it in VBA to make it prompt for selection (inputBox("what do you want" vbokonly) or something like that.

Collapse -

by Borg7of9 In reply to

Poster rated this answer.

Collapse -

by Borg7of9 In reply to Excel problem

I can not import it, I want to be able to fill the form with data from any one of the colums, for example if I fill the form with data from colum 23, then print, next I may then want to fill it with data from colum 14.

Collapse -

by chitosunday In reply to Excel problem

Try data filter advance filter copy to another location. Just put the heading you want in the destination of "copy to another location". Then filter it using criteria like your data date or data id number if you have one.

Collapse -

by anikmankar In reply to Excel problem

use combination of Vlookup to search and get the column information.

Related Discussions

Related Forums