User Profile
wsantos
Brass Contributor
Joined 7 years ago
User Widgets
Recent Discussions
Re: Which formula to use when i want to have return a value based on a range of cells having a value
Stephen_Appleby5574 If you always average from week 1 through the current week, just fix the start cell. Ex: Average(a$1:a34). If there are no other weeks on the column that need to be filtered out you could average the whole column. It really depends on the actual spreadsheet content, so without seeing a sample it's impossible to tell.Re: How to create a report based on a dynamic list of sheets?
AustinAdams A few things that come to mind (in no specific order): 1 if the employee list doesnt' change much, you could SUMIF across the worksheets 2 use a powerquery to merge all data together, then just use a pivottable. Not sure how you'd handle multiple dynamic worksheets there though. 3 try a webquery to pull the data from the webpage directly (if this is not coming from a regular app), and see what you get in return. 4 build a macro to loop through the worksheets and copy/paste the data in a new consolidated spreadsheet - this could be the easiest one good luckRe: How to create a report based on a dynamic list of sheets?
AustinAdams You can sum all worksheets automatically, but you many need to add a dummy one at the left and right sides so you don't need to edit the formulas each time: https://exceloffthegrid.com/how-to-sum-the-same-cell-across-multiple-worksheets/Re: Excel print problem
DJCW53 On print preview, check how many pages it says it would print. If it seems reasonable, try printing to a different printer - set it offline just so you see the size of the printed file. If it all looks good, you may actually want to go ahead and print. If it still works, you may want to try and reinstall your printer driver.
