Link to home
Start Free TrialLog in
Avatar of mcrmg
mcrmg

asked on

SQL to Excel template

Hi,

We have an Excel template with logo, headers, etc...

Is there a way to "assign" values to specific cells in excel?  thx
ASKER CERTIFIED SOLUTION
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mcrmg
mcrmg

ASKER

that's ok....I checked how to create name range in excel, which is cool...

when you are free, can you point me to some examples that can grab data from SQL?  thx
Avatar of mcrmg

ASKER

I think I got to work now, if I have other questions, I will open a new question, but this is a great start...thank you
<off the call>

>Is there a way to "assign" values to specific cells in excel?
If we're talking single cells then yest most exports to Excel methodology will have a parameter where you can assign whatever to a single cell.

If we're talking assigning a set of data to multiple cells, then the named range usually works.

Thanks for the grade.  Good luck with your project.  -Jim