HELP!!!!!!

[dredpipin]

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]

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]

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/preview.aspx?scid=kb;en-us;Q214246

 

[dredpipin]

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]

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]

Dredpin,

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