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 use 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
This seems to be a duplicate post, already posted in Excel General forum.
Automatically transfer data from one sheet to another
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
Something like this should work. Press Ctrl + Shift + Enter as it is an array formula, then you can copy down and over. If this doesn't work perhaps you should upload a sample workbook.
Formula:
Please Login or Register to view this content.
Despite the high cost of living, it remains very popular.
Don't forget to mark threads SOLVED when you get an answer and rep all the geniouses that helped you today!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks