VB/Macro to replicate data ?!

[Dhimit]

G'Day folks,

Can somebody please give me a 'STEP BY STEP' instruction (use of Macro/VB code?!) to replicate data from one or more worksheets to a TARGET worksheet ?

For example, if i create a record in 'XYZ' worksheet, it should create the same record in TARGET worksheet.
Likewise, if i create a record in 'ABC' worksheet in the same workbook, it should create the same record in the SUBSEQUENT ROW of the TARGET worksheet.

For this to happen, it must be done programmitically either using a MACRO or VB Script.

Are there any 'Excel experts' out there who can help me achieve my goal ?

Dhimit

 

[Dhimit]

Re:

Thanks.

The original piece of code does exactly what's it supposed to do !(Start of this thread)

All i need is to copy ROW DATA from COL.A to COL.F from a SINGLE SOURCE worksheet to next available row on TARGET worksheet.

Can you have a look @ the code again (what i posted 2'day) 'coz that's all i want & it works fine on another spreadsheet !

Is the problem due to change of MS Office from '03 to '07, do u think ?

Rgds - DC

 

[stanleydgromjr]

DC,

Are we just copying the active row (in just the active sheet), columns A, B, C, D, E, F, to the next available row in the Target worksheet?

It may make a difference - what version of of Excel are you using the macro in?

And:

Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Colo's HTML Maker.

[url]http://www.puremis.net/excel/downloads.shtml
[/url]

Or, with Excel Jeanie HTML 4.

Try posting a small example of wha...http://www.excel-jeanie-html.de/index.php?f=1
[/url]

Have a great day,
Stan