Automatically transfer data from one sheet to another

Closed
kishn697 Posts 1 Registration date Wednesday June 18, 2014 Status Member Last seen June 18, 2014 - Jun 18, 2014 at 06:46 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 19, 2014 at 10:58 AM
Hello,
I have a workbook in sheet1 details of materials issued to dealer for job work
Sheet1 Columns: Dealer name, Date, Challan No, Item, Qty, etc
I want to make each dealers sheet in this workbook. I dont want to go filter I used formula in dealer sheet
(=IF(Sheet1!A2="ABC", Sheet1!B2,0) and drag them but there are lot of gaping in rows
I'm new to these forum and Excel itself any assistance is greatly appreciated.

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jun 19, 2014 at 10:58 AM
Hi Kishn697,

Let me see if I understand you correctly.

Loop through sheet1 column A. The values here are also sheet names. Each row needs to be copied to its corresponding sheet.

Is this what you meant?

Best regards,
Trowa
-1