Hello, I need help to generate a report (Sheet "Report-A" & "Report-B" ) based on the dates (column F) and delivery notes (column E) from the master file. Sample workbook attached.
Thank you.
Hello, I need help to generate a report (Sheet "Report-A" & "Report-B" ) based on the dates (column F) and delivery notes (column E) from the master file. Sample workbook attached.
Thank you.
File not attach. Plz attach file.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
There is no workbook attached.
To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.
Note that the Paperclip icon does not work.
Hope this helps.
Pete
Sorry.. I submitted a new thread.
Last edited by sharathnarayanan; 01-27-2017 at 05:09 AM.
You didn't need to start a new thread.
Pete
sample workbook attached.
Try
in E7 of "Report_A"
=SUMIFS(Master!$P:$P,Master!$F:$F,$A7,Master!$E:$E,$B7)
format as 0;;;@
in F7
=SUMIFS(Master!$Q:$Q,Master!$F:$F,$A7,Master!$E:$E,$B7)
format as 0.00;;;@
in Report_B
in D19
=delivery_Notes(DELIVERY_NOTE)
Concatenates Delivery notes (5 per "line")
DELIVERY_NOTE is named range
Please Login or Register to view this content.
Last edited by JohnTopley; 01-28-2017 at 01:10 PM.
Thanks for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks