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
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,456
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,835
Messages
5,855,907
Members
431,772
Latest member
dannyboi1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top