excel
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Other forums
- :
- Tech Help - Software/Hardware etc
- :
- Re: excel
excel
16-06-2017 2:47 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
any excel gurus here?
I have a spreadsheet with 2 sheets.
"Front Sheet" and "Data".
The Data sheet contains all the raw data.
The Front Sheet contains stats based on what is in the Data sheed (using formulas and calcuations etc).
What I am looking to do is display a sub-set of data from the Data sheet on the Front Sheet based on certain criteria.
The amount of data brought forward from that sheet could vary, so it could be 2 rows or 12 rows of data (for example).
Is there a way to do that in Excel?
Basically it would be pulling all data where column E is "blah", for example.
It would need to do this withouth any user interaction. All they would do is paste the raw data into the Data sheet and everything would automatically populate on the Front Sheet.
Re: excel
16-06-2017 3:01 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
have you tried using pivot tables
Re: excel
16-06-2017 3:12 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Re: excel
16-06-2017 3:15 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
depends on how you set it up although it is many years since I used them
Re: excel
16-06-2017 3:21 PM - edited 16-06-2017 3:22 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
the only user input that can happen is the copying and pasting of the raw data into the sheet.
I thought it might require something along the lines of a VBA function with an array of some sort.
Re: excel
16-06-2017 3:27 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
If you're comfortable using Python then you can get the user to supply the raw data as CSV then use openpyxl to create the document, load the sheet and create the formula based on the number of rows imported. I'll gladly help you with the Python if you want.
Re: excel
16-06-2017 3:43 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
it'll need to be a simple copy and paste job into the existing excel spreadsheet.
Re: excel
16-06-2017 4:24 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
vLookup?
To argue with someone who has renounced the use of reason is like administering medicine to the dead - Thomas Paine
Re: excel
16-06-2017 5:28 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
the amount of rows would vary.
plus it would need to match on something on the first sheet, which there wouldn't be.
Re: excel
16-06-2017 6:35 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
as I said I am way out of touch but I seem to remember doing something like that using pivot tables and a macro button
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page