LinkBack URL
About LinkBacks
Good day,
I have this Monthly Reporting sheet and I want to eliminate manual data scraping from RawData to specific date range.
1. Extract all data depending on Start Date and End Date in Macro Tab
Thank you.
Please see attached file for references.
Good day,
I have this Monthly Reporting sheet and I want to eliminate manual data scraping from RawData to specific date range.
1. Extract all data depending on Start Date and End Date in Macro Tab
Thank you.
Please see attached file for references.
Last edited by 323100N; 04-11-2019 at 09:18 AM.
You may have attached the wrong workbook as that one doesn't have a VBA project attached to it. At the very least we're going to need to see your code in order to offer advice.
If you haven't written any code yet please start here: https://www.excelforum.com/excel-pro...materials.html
Hi,
I need to read multiple Dat files and serach for particular text from the list captured into one excel sheet . If match is not found I need to capture file name for that dat file.
Could some one pls help .
Anupam, you're going to need to start a new thread for your request.
Thank you for the references, I have attached updated workbook with code that I found in google but I cannot extract all the information needed in the RawData. Only the header was extracted from the RawData.Originally Posted by BellyGas
@Anupam Preeti
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
any idea guys?
If a formula based solution is acceptable you might try the following, as modeled on Sheet3:
1. Populate A5 and down using:Formula:
Please Login or Register to view this content.
2. Populate columns B: (starting with row 5) using: =IF($A5="","",INDEX(Table1[Pipeline Description],MATCH($A5,Table1[[Client Name]:[Client Name]],0)))
Note that zero values are hidden using conditional formatting.
Note that some columns containing dates need to be formatted as such.
Note that this proposal assumes 'Client Names' are unique and selection of rows should be based on 'Due Date'.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
vba
Please Login or Register to view this content.
Both works perfectly, Thank you!
You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks