Copy SHeets coloumn in Other Sheet

[vajeednawab]

Dear Sir,

I would like to Copy The (Sheet 2 Column A) to (Shee1 Column B) in the Same Workbook named Test through VBA, And I need not see Zero Values, Like This I have 4 to 5 Columns In Sheet 2.

And This should be done without any command button means Automatically in sheet1 the values should update.
Values should come in descending order.


Regards,
Vajeed

[JOHN H. DAVIS]

Duplicate post.

http://www.excelforum.com/excel-prog...her-sheet.html

[xladept]

Hi Vajeed,

Try this in the Sheet2 module:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Press ALT + F11 to open the Visual Basic Editor.

Open a macro-enabled Workbook or save your Workbook As Macro-Enabled

Click on "Sheet2"

Type "Option Explicit" then paste the code under it

And, you should be ready to go

[vajeednawab]

Its Not Working

[xladept]

Vajeed.xlsm - just edit any entry on sheet2

[vajeednawab]

Sorry My Mistake Very Good answer

[xladept]

Glad it's working - Thanks for the rep!