View Single Post
 
Old 06-08-2014, 07:57 PM
TBD TBD is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Jun 2014
Posts: 2
TBD is on a distinguished road
Question Convert non-cell input to cell values

Ok, I realize the title was kinda rough, but let me explain.

I would like to make it so that I user can simply type items in the form of a tabbed list like this: (I had to use "-" instead of " " or tab because of the forum formatting)

Name 1
----Detail 1
----Detail 2
----Detail 3
Name 2
----Detail 1
----Detail 2

and have it come out in excel like this:

A---------- B
Name
--------Detail 1
--------Detail 2
--------Detail 3
Name
--------Detail 1
--------Detail 2



I want to do this because then I can set up formulas to automatically formulate whatever is necessary to match the required information, while also being able to search each entry for keywords as needed. This can't all be done in cell however, as you cannot press enter in a cell, and if you do anything funny after tabbing over to column B then pressing enter will simply put you to the next row of column B, instead of the next row back in column A. So is there any way for me to pull data from a text box? Or to have excel open a text document, save it under a specific name, and then pull data from it after the user saves it again?

I'm trying to make my worksheet dynamic and idiot proof all in one go, and it's proving rather difficult.
Reply With Quote