I am looking to create a front sheet for an Excel Workbook capable of pulling rows of information from other sheets in the Workbook, based on whether specific cells have/don't have anything entered in them.
Is this possible?
I am looking to create a front sheet for an Excel Workbook capable of pulling rows of information from other sheets in the Workbook, based on whether specific cells have/don't have anything entered in them.
Is this possible?
It is possible for sure. Depending on your data layout and what you need to pull, you can use VBA or formulas
Click the * to say thanks.
Do you have an example of a formula that could be used? The rows of data I want to pull are are 8 cells long and would be based on the last cell having text in or being blank
Hello josh_horley14 and Welcome to Excel Forum.
It may help if you could upload a small desensitized sample of your workbook by clicking on the GO ADVANCED button below the Quick Reply window and then scrolling down to Manage Attachments to open the upload window.
I would also suggest that if you are pulling rows from more than a couple of sheets, that you ask the moderator to move this thread to the VBA forum.
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.
I've attached the sample workbook to this reply, if anyone could take a look at it for me I would appreciate it. I don't know who to ask to move it over to the VBA forum.
Compile some example in sheet1 based on sheet 2. To use formulas you need a link key between pages, like category name.
I am asking as I fail to understand why you would keep lines of data with same headers in the same row and not adding them one under another.
Try this attachment?
I assume from post #3 that the "last cell" is in the "Sent To" column.
I also assume that if there is some text in that column that you want the Category, Date Received, Date Due Back, Commander, Inspector and Date Inspection Complete to be placed in a table like the one on Sheet1.
If these assumptions are correct you may be able to use Get & Transform found on the Data tab to produce a append table such as All_Tables found on sheet 3.
A connection only is made to the three tables on Sheet 2 then the three connections are then appended.
The columns that you want to see are left unhidden with the exception of the Sent To and Sent To 2 columns which are grouped so that you can select the filter from the Sent To column.
Let us know if you have any questions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks