Copy a range of cells to another worksheet

Closed
sac_goel Posts 1 Registration date Wednesday March 31, 2010 Status Member Last seen March 31, 2010 - Mar 31, 2010 at 12:10 AM
 Blocked Profile - Apr 2, 2010 at 05:52 AM
Hi, I have a workbook containing multiple worksheets. I enter data manually in all the worksheets except one say worksheet "X". My requirement is to populate a range of cell in "X" from other worksheets based on a condition. The condition is " If a column G in other worksheets contains value 'Test', then copy range A:F to range A:F of worksheet "X". I should also be able to know that the cells that are copied are from which worksheet."

Any help will be appreciated in this context.

Thanks...

1 reply

Blocked Profile
Apr 2, 2010 at 05:52 AM
Hello Sir,

To do this you will need a macro,

Please click here to know more:

https://ccm.net/faq/6033-excel-copy-data-from-one-sheet-to-another

Thanks
0