|
More site info...
Microsoft Excel | Forum profile
|
|
Forum profile page for Microsoft Excel on http://www.dbforums.com.
This report page is the aggregated overview from a single forum: Microsoft Excel, located on the Message Board at http://www.dbforums.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "Microsoft Excel" on the Message Board at http://www.dbforums.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on Microsoft Excel:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
9
|
39
|
134
|
|
Post:
|
27
|
102
|
304
|
|
|
Microsoft Excel Posting activity graph:
|
Top authors during last week:
user's latest post:
If formula (Scratching my brain)
Published (2009-12-14 11:54:00)
Hi, Sorry, I want to help but I just don't get this at all. The 2009 and 2010 tabs seem to be an accrued total payment. So he would have to look in the relevant cell for the client and then add $20 to it if a new payment has come in - is that right? So, change $120 to $140. And then you want that reflected on Sheet1? But how is that better for him than just having Sheet1 (remove the others) and just to type $20 in under the correct date?...
user's latest post:
Column counts w/Look up cells...
Published (2009-12-08 11:48:00)
Colin ~ Thank you so much for your help! Absolutely amazing. I added 0+ at the beginning of the LOOKUP formulas in each cell and add the SUMIF. SHAZAAM! Thanks again
user's latest post:
Check boxes
Published (2009-12-07 21:15:00)
it's all fine now. i was making a mountain out of a molehill. All i needed to do was change the value of Me.hcc.Value = "" to Me.hcc.Value = False It works fine now. Thanks for all of your help.
user's latest post:
If formula (Scratching my brain)
Published (2009-12-14 09:56:00)
If the amount on 2009 tab is changed from 120 to 140 for the next month, then $20 should remain in June and $20 should be added to July. The amount should not go over $240
user's latest post:
Counting instances of specific...
Published (2009-12-07 15:37:00)
Yes! Yes that helps much and perfectly! Thank you for your response. I had a feeling it was going to be something really simple.
user's latest post:
Marco to hide blank rows
Published (2009-12-07 06:06:00)
The Matrix is in C4:G6 and do not contain any formulae. Connor
Colin_L Colin_L is offline...
1
Colin_L Registered User
1
user's latest post:
Check boxes
Published (2009-12-08 04:54:00)
Glad you got it sorted, Cunnie. Good luck with the rest of your project.
MillB MillB is offline...
1
user's latest post:
Column counts w/Look up cells...
Published (2009-12-08 11:48:00)
Colin ~ Thank you so much for your help! Absolutely amazing. I added 0+ at the beginning of the LOOKUP formulas in each cell and add the SUMIF. SHAZAAM! Thanks again
|
|
|
|
Latest active threads on Microsoft Excel::
Started 4 days, 2 hours ago (2009-12-12 07:25:00)
by Colin_L
Hi Fire Alarm,
I'm having a little bit of trouble trying to envisage your set-up. Would it be possible for you to zip and attach an example workbook?
Thanks
Started 1 week, 1 day ago (2009-12-07 18:14:00)
by Colin_L
I already provided a solution on your other thread here, right?
SUM column totals when there's #N/A
Or was that question different? As I said on that other thread, option 3 is definitely a viable option. If it doesn't work and has been correctly implemented then it means that the underlying data is numbers stored as text rather than numbers. If you're still having trouble then I suggest...
Started 1 week, 5 days ago (2009-12-04 04:52:00)
by pootle flump
Checkbox values are true or false (or NULL if excel allows tristate, but I don't think it does). True and False are enumerated constants in VBA, equating to -1 and 0 respectively.
What does all that mean? It means if you want to "clear" a checkbox, set its value to False. VBA will recognise False as a name representing the value 0. Similarly, to set them to "ticked" then assign the value True,...
Started 1 week, 1 day ago (2009-12-07 14:24:00)
by Colin_L
Hi,
Quote:
I've got a very simple task. I've got a range of say H10:H39. Each of these cells is going to either say Y, N, or NA - I want to just ... have a cell beneath the column that sums up the number of Ys in the range. That is all.
This can be done with a formula, so there's probably no need to use Excel VBA. It's really a count, not a sum,...
Started 1 week, 4 days ago (2009-12-04 11:48:00)
by Colin_L
Conceptually the approach would be:
Code:
Sub foo()
Dim rngCell As Range
For Each rngCell In Range("A10: A20")
rngCell.EntireRow.Hidden = IsEmpty(rngCell)
Next rngCell
End Sub
A10:A20 would be the range containing the "x=y" etc.. values. Presumably this would have to be determined at runtime - I can't suggest the code to do that because there ...
Started 1 week, 4 days ago (2009-12-04 11:39:00)
by Colin_L
Hi,
I would recommend that you amend your current code so that it breaks the individual detail into different distribution workbooks. Each distribution workbook should only contain data that the relevant rep should be able to see (this sounds like it would be one worksheet per workbook). A clever user would be able to bypass any security you impose within the workbook so hidden or protected ...
Started 1 week, 6 days ago (2009-12-03 09:12:00)
by Colin_L
Hi,
I can't see any spreadsheet pictures in your post (there is only an advertising banner) so I'm going to improvise an example.
Btw - rather than linking an image to a 3rd party site, it would be much better to attach a workbook which we can experiment with.
Anyway...
The fact that they are sorted in Customer Number order, with the new above the old, makes life much easier. ...
Started 1 year ago (2008-11-22 02:18:00)
by goksu Registered User
hello,
I am using some very old software where I can only import dbf files for massive updates.
now Excel 2007 does not save dbf files.
What is there I can do to save dbf files from excel 2007?
vba code, addon, other trick?
thank you
Started 9 months, 4 weeks ago (2009-02-19 10:32:00)
by Rozza Registered User
Dears,
Well I need to add a specific value to a formula in many cells at the same time...and that formula is linked to another workbook
Doing it manually is taking a lot of time
for example:
='[01 Time Sheets.xls]02'!$BJ$8 and I need to make it multiplied by a specific cell to be ='[01 Time Sheets.xls]02'!$BJ$8*B6
for around 700 cell without changing the formula itself as the...
|
|
Hot threads for last week on Microsoft Excel::
Started 1 week, 1 day ago (2009-12-07 18:14:00)
by Colin_L
I already provided a solution on your other thread here, right?
SUM column totals when there's #N/A
Or was that question different? As I said on that other thread, option 3 is definitely a viable option. If it doesn't work and has been correctly implemented then it means that the underlying data is numbers stored as text rather than numbers. If you're still having trouble then I suggest...
Started 1 week, 5 days ago (2009-12-04 04:52:00)
by pootle flump
Checkbox values are true or false (or NULL if excel allows tristate, but I don't think it does). True and False are enumerated constants in VBA, equating to -1 and 0 respectively.
What does all that mean? It means if you want to "clear" a checkbox, set its value to False. VBA will recognise False as a name representing the value 0. Similarly, to set them to "ticked" then assign the value True,...
Started 4 days, 2 hours ago (2009-12-12 07:25:00)
by Colin_L
Hi Fire Alarm,
I'm having a little bit of trouble trying to envisage your set-up. Would it be possible for you to zip and attach an example workbook?
Thanks
Started 1 week, 1 day ago (2009-12-07 14:24:00)
by Colin_L
Hi,
Quote:
I've got a very simple task. I've got a range of say H10:H39. Each of these cells is going to either say Y, N, or NA - I want to just ... have a cell beneath the column that sums up the number of Ys in the range. That is all.
This can be done with a formula, so there's probably no need to use Excel VBA. It's really a count, not a sum,...
Started 1 week, 4 days ago (2009-12-04 11:48:00)
by Colin_L
Conceptually the approach would be:
Code:
Sub foo()
Dim rngCell As Range
For Each rngCell In Range("A10: A20")
rngCell.EntireRow.Hidden = IsEmpty(rngCell)
Next rngCell
End Sub
A10:A20 would be the range containing the "x=y" etc.. values. Presumably this would have to be determined at runtime - I can't suggest the code to do that because there ...
|
|
Size: 190 bytes
