Hey I have noticed in my career people love using Excel as a form to collect information. I have worked for multiple companies and this always seems to be true.
Right now I need to create a data-set out of two different forms which get filled out daily. Each Day is on a separate tabs and each week is in a separate file. I know this is a very common problem in corporate America. This is not the first time I have run into something like this nor will it be the last.
Is there a generic Marco anyone has made or used, or even software I can buy that can open multiple excel files and pull information based on given descriptions and rules. I am really just looking to pull whole rows including the heading incase someone decided to add extra columns.
I am not confident the Cells always stayed the same for the header information I need to pull into each record so I would need it to be description based. Also each tab would have multiple records I would have to pull that in (also a common problem). I don't mind pulling blank data or cells because that is easy to filter out.
Also some of the information is formula driven other times the exact same data is not formula driven. Not sure if that would matter. Attached is an example of the two types of data I am trying to pull with what I am trying to pull into each record highlighted.
I can work out the logic but I so rarely use VB so I have forgotten most of what I knew other than the basics and my understand was fairly limited to start with.
Seriously, if someone created a piece of software that was dynamic in the type of rules you could create and would pull all files and tab from a given folder location, you could make some decent money selling the solution because this is a very common problem.
Right now I need to create a data-set out of two different forms which get filled out daily. Each Day is on a separate tabs and each week is in a separate file. I know this is a very common problem in corporate America. This is not the first time I have run into something like this nor will it be the last.
Is there a generic Marco anyone has made or used, or even software I can buy that can open multiple excel files and pull information based on given descriptions and rules. I am really just looking to pull whole rows including the heading incase someone decided to add extra columns.
I am not confident the Cells always stayed the same for the header information I need to pull into each record so I would need it to be description based. Also each tab would have multiple records I would have to pull that in (also a common problem). I don't mind pulling blank data or cells because that is easy to filter out.
Also some of the information is formula driven other times the exact same data is not formula driven. Not sure if that would matter. Attached is an example of the two types of data I am trying to pull with what I am trying to pull into each record highlighted.
I can work out the logic but I so rarely use VB so I have forgotten most of what I knew other than the basics and my understand was fairly limited to start with.
Seriously, if someone created a piece of software that was dynamic in the type of rules you could create and would pull all files and tab from a given folder location, you could make some decent money selling the solution because this is a very common problem.
