Populating Excel from CSV

  • Thread starter Thread starter AJMorgan591
  • Start date Start date
A

AJMorgan591

Hello all,
I need to know how to populate an Excel template with data from a
external CSV file. Let's say I have this nice pretty colourful templat
that is far more pleasing to the eye than the usual chunk of importe
CSV data, what are some methods to populate it with data from a CS
file??

Any ideas or suggestions or redirections would be much appreciated.

Thanks in advance :
 
Bob said:
Have you tried File/Open?
Click to expand...

Are you being smart or dumb??
If you're meaning I should use File --> Open to open a CSV file, ho
does that auto populate my template?? All that will achieve is openin
the CSV data in a new workbook
 
Hi

That type of response is hardly going to endear you to members of this
NG who give their time and help freely to try to help people.
Bob is a regular contributor who has helped numerous people in the past.
I guess he won't be too keen on helping you in the future!!

Having opened the file, you could Copy and Paste Special>Values to your
Template.

Regards

Roger Govier
 
Roger said:
Hi

That type of response is hardly going to endear you to members of this
NG who give their time and help freely to try to help people.
Bob is a regular contributor who has helped numerous people in th
past.
I guess he won't be too keen on helping you in the future!!

Having opened the file, you could Copy and Paste Special>Values t
your
Template.
Click to expand...

Well to be honest with you Rog if Bobby is going to give me smar
answers like that then I don't really want his 'help' do I, but thank
very much for your far more constructive response and suggestion - muc
appreciated
 
Hi

Well thank you for your response. I'm glad it helped.

However, whilst my role is not to defend Bob or any other regulars round
here, I am absolutely positive that Bob's response wasn't meant to be
"smart" or flippant.
Very often, a quick simple response is all that is needed to point
someone in the right direction, especially when sometimes one "cannot
see the wood for the trees" because you are too close to the problem.
The fact that you know how to create templates would probably have lead
him to believe that you would understand that copying and pasting values
would then have worked.

You obviously are a decent guy (otherwise you wouldn't have posted a
thanks), but perhaps don't be too quick to misjudge well intentioned
responses from others.

(Here endeth the lesson ....!!! <vbg>)

Have a great day.

Regards

Roger Govier
 
Back
Top