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
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.
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.
Related:
- Automatically transfer data from one sheet to another
- Transfer data from one excel worksheet to another automatically - Guide
- Free fire transfer - Guide
- Google sheet right to left - Guide
- How to automatically transfer data between sheets in Excel - Guide
- Download automatically while roaming - Guide
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
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
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