146 reputation
7
bio website
location
age
visits member for 3 years, 3 months
seen Oct 17 at 18:02

Oct
17
accepted Have Pivot Chart show only some columns in pivot table
Oct
17
comment Have Pivot Chart show only some columns in pivot table
I used number 2 and it did exactly what I wanted. Thank you very much.
Sep
23
asked Have Pivot Chart show only some columns in pivot table
Jun
3
comment Lifetime of flat panel monitor - Taking into account dimming and not just stop working
Thanks for the info but I have a follow up. How do you know the 7 year old monitor is working absolutely fine? My question is asking about things that are not obvious. You may look at a monitor and think it looks fine but you also may have eye strain and lean closer to your monitor to see, and not even know you're doing it.
Jun
3
asked Lifetime of flat panel monitor - Taking into account dimming and not just stop working
May
14
revised Click on link to shared drive in Lotus Notes email, opens in Firefox instead of Windows Explorer
deleted 151 characters in body
Mar
28
comment Click on link to shared drive in Lotus Notes email, opens in Firefox instead of Windows Explorer
First setting already in place. Second one, even if I click the chain link and paste in the exact destination I want, as soon as I hit OK, all the \ in the Name stay the same but all the \ in the Link are magically turned into /.
Mar
28
asked Click on link to shared drive in Lotus Notes email, opens in Firefox instead of Windows Explorer
Feb
4
accepted Automating Access 2007 Queries (changing one criteria)
Feb
3
awarded  Popular Question
Jul
11
accepted Error when copying from a PDF into file name
Jul
11
comment Error when copying from a PDF into file name
This is the solution I was looking for.
Apr
24
comment Using an array formula to add up several cells in another worksheet (using INDIRECT)
It looks like I can use the sumif suggestion, so +1 and thanks. I would still like to know how to use an array formula in general though.
Apr
23
asked Using an array formula to add up several cells in another worksheet (using INDIRECT)
Oct
23
accepted Searching Excel sheet for errors
Oct
23
comment Searching Excel sheet for errors
It looks like it's tab to go between them, not enter. Other than that, this seems like what I was looking for! Thanks!
Oct
23
asked Searching Excel sheet for errors
Aug
3
awarded  Tumbleweed
Jul
27
comment Excel 2007 table gets data from Access 2007 Table or Query
@Excellll Part of the problem is I have around 150 fields, so it's sort of a pain... and I've already built a query in a specified order in Access. Why do I need to do it twice? I checked the SQL View in Access and the SQL there brings in the fields in the order I want, and the Design view shows them in that same order. But, when I import to Excel, if I have made changes, it does not come in that order.
Jul
27
comment Excel 2007 table gets data from Access 2007 Table or Query
@Excellll Maybe... maybe I could just change the query in Access to a make table query (instead of a select) and connect to that.