HELP!!!!!!

dredpipin · Mar 13th, 2002, 07:04 AM

I NEED 2 KNOW HOW 2 COPY DATA VIA A MACRO FROM ONE WORKBOOK TO ANOTHER REPEATEDLY.E.G FROM AN INVOICE SHEET TO A CUSTOMER PROFILE WORKBOOK.PLEASE RESPOND ASAP

Derek · Mar 13th, 2002, 07:34 AM

Hi dredpipin
You will need to give more details. Are you copying entire rows, individual cells, whole ranges? Where exactly do you want them to end up? Try to give a simple but precise example.
regards
Derek

lenze · Mar 13th, 2002, 07:39 AM

Perhaps instead of copying, you could make your Workbook a template and use the Template Wizard with Data-Tracking Add-in. See the link below for info.

http://support.microsoft.com/search/...;en-us;Q214246

dredpipin · Mar 13th, 2002, 07:42 AM

i want 9 cells of information to be transfered from an invoice sheet and placed into another workbook where i want the details to be displayed.it will contain digits and letters but no formulas.

Derek · Mar 13th, 2002, 08:42 AM

To record a macro:
go to Tools, Macro, Record New Macro.
A dialogue box will open where you can name your macro and designate key strokes to run it. From then on every action you take will be recorded in code. Just select the area you wish to copy, then select the workbook and worksheet you want it to go to and paste it. Press Esc on your keyboard (ends copy mode)
go to Tools, Macro, Stop Recording.
Now when you use your designated keystrokes the macro will copy from the same range and paste to same range exactly as you recorded it.
If you wish you can assign this macro to a button. You do this by customising your toolbar. Select the button icon from the Forms section. Click on this icon to draw an oblong button on your sheet. Right click the button and select Assign Macro. select your macro's name.
Hope this helps
regards
Derek

Chris Davison · Mar 13th, 2002, 01:49 PM

Dredpin,

is this from a sales invoice sheet or from a purchase invoice sheet ?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 07:04 AM	#1
dredpipin New Member Join Date: Mar 2002 Location: london Posts: 5	I NEED 2 KNOW HOW 2 COPY DATA VIA A MACRO FROM ONE WORKBOOK TO ANOTHER REPEATEDLY.E.G FROM AN INVOICE SHEET TO A CUSTOMER PROFILE WORKBOOK.PLEASE RESPOND ASAP

Mar 13th, 2002, 07:34 AM	#2
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Hi dredpipin You will need to give more details. Are you copying entire rows, individual cells, whole ranges? Where exactly do you want them to end up? Try to give a simple but precise example. regards Derek

Mar 13th, 2002, 07:39 AM	#3
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Perhaps instead of copying, you could make your Workbook a template and use the Template Wizard with Data-Tracking Add-in. See the link below for info. http://support.microsoft.com/search/...;en-us;Q214246

Mar 13th, 2002, 07:42 AM	#4
dredpipin New Member Join Date: Mar 2002 Location: london Posts: 5	i want 9 cells of information to be transfered from an invoice sheet and placed into another workbook where i want the details to be displayed.it will contain digits and letters but no formulas.

Mar 13th, 2002, 08:42 AM	#5
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	To record a macro: go to Tools, Macro, Record New Macro. A dialogue box will open where you can name your macro and designate key strokes to run it. From then on every action you take will be recorded in code. Just select the area you wish to copy, then select the workbook and worksheet you want it to go to and paste it. Press Esc on your keyboard (ends copy mode) go to Tools, Macro, Stop Recording. Now when you use your designated keystrokes the macro will copy from the same range and paste to same range exactly as you recorded it. If you wish you can assign this macro to a button. You do this by customising your toolbar. Select the button icon from the Forms section. Click on this icon to draw an oblong button on your sheet. Right click the button and select Assign Macro. select your macro's name. Hope this helps regards Derek

Mar 13th, 2002, 01:49 PM	#6
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Dredpin, is this from a sales invoice sheet or from a purchase invoice sheet ?