specific need from excel... is it for a macro?

[carmacoma]

Hey All,

Apologies if this is answered elsewhere, or is commonly known to most excel users...

I want to be able to enter a few different cells of data into a sheet, and then be eble to click a button/use a shortcut for excel to then take that specific data (all on the one row, but in different cells) and generate a new document from a pre existing template, filling in specific cells in the new doc with the data just entered.

Is this just a pipe dream? Or can it be done - if so, where to start??

Cheers,
Carmacoma

 

[HalfAce]

Hello carmacoma, welcome to the board.
Sure, this is easily done. Going to need some more info from you first though.
What is the name of the pre existing template?
What range (which cells) are you entering the data in on the (blank?) sheet?
What are the destination ranges in the pre existing template?

You can probably do most of it by yourself by using the macro recorder.
Then you can post your code here and someone will help you clean it up and make
any changes you want to make.

You very likely don't even need any macro at all and can do it with sheet formulas instead.
(In sheet2, cell B5, enter = then select sheet1 and click in a cell (say A1) and
press Enter.
Now go to sheet 1 and enter something in A1. Then go back to sheet2 and B5 will display
what you just entered in sheet1 A1.)

Will that get you what you're looking for?

 

[carmacoma]

Thanks very much!

I am trying it now - I will post back to let all know how I've gone, and for the inevitable "further help needed!" post...

Cheers.