Excel Q&A
Ask your geeky hard core Excel questions here!
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
Ask your geeky hard core Excel questions here!
There are two columns, A.) Name and B.) Dollars
The bottom row is a SUM of all the dollars above
The columns remain static, but the rows will change depending on how many people the Access query returns.
1. Does Excel have a method to paste the data from access, and automatically expand or contract the rows to the number of rows necessary.
2. Does Excel have a method to automatically sort by dollars largest to smallest other than a filter I would have to manually reset with each report?
Keep in mind that I need the bottom row containing the SUM function to always be directly below the pasted names and dollar figures.
Thank you! Read More