Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
update excel with data from text file??
6 views
Skip to first unread message
PAkerly
Oct 20, 2011, 4:58:51 PM10/20/11
to
I want to update excel with data from a text file...is this possible?
Basically I have a text file that has a lot of stuff in it but I am
interested in the lines that begin with *D
so those lines would look like this:
*D11200120 12 250
*D25012002 18 111
etc...
And so I want to update an excel file and a certain sheet within this
file
so cell would be updated as follows:
B2 = *D11200120
C2 = 250
B3 = *D25012002
C3 = 111
etc.
Can anyone give me examples of how to do this?
Basically I have a text file that has a lot of stuff in it but I am
interested in the lines that begin with *D
so those lines would look like this:
*D11200120 12 250
*D25012002 18 111
etc...
And so I want to update an excel file and a certain sheet within this
file
so cell would be updated as follows:
B2 = *D11200120
C2 = 250
B3 = *D25012002
C3 = 111
etc.
Can anyone give me examples of how to do this?
Jesse
Oct 21, 2011, 7:22:36 AM10/21/11
to
effectively import in to excel and use like a VLOOKUP on a loop
through the whole file... Look up and learn that function and see
where it takes you.
Jess.
0 new messages