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
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 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 reply

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
514
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