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

carmacoma

New Member
Joined
Sep 25, 2006
Messages
2
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
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,453
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

New Member
Joined
Sep 25, 2006
Messages
2
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,111,910
Messages
5,541,541
Members
410,547
Latest member
htran4
Top