|
More site info...
Excel Programming | Forum profile
|
|
Forum profile page for Excel Programming on http://www.excelforum.com.
This report page is the aggregated overview from a single forum: Excel Programming, located on the Message Board at http://www.excelforum.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 "Excel Programming" on the Message Board at http://www.excelforum.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 Excel Programming:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
765
|
2,461
|
6,836
|
|
Post:
|
2,523
|
8,011
|
23,314
|
|
|
Excel Programming Posting activity graph:
|
Top authors during last week:
user's latest post:
Use VBA to call hyperlink where...
Published (2009-11-25 12:45:00)
Thanks for posting your resolution but going forward please be sure to use CODE tags - I have on this occasion added them for you. FWIW I would have suggested / opted for something like: Code: Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean) Dim rngDates As Range Select Case UCase(Sh.Name) Case "JAN", "FEB", "MAR",...
user's latest post:
variable scope within functions
Published (2009-11-25 19:01:00)
I should add that if the variables don't need to be seen outside the module in which they are declared, replace Public with Dim
user's latest post:
if/then formula containing...
Published (2009-11-25 18:32:00)
Hi Caboose, welcome to the forum. It's not lame, it's just not as clear as you'd think. Does A1 have multiple values in it? Mockup a sample workbook showing the dilemma and your desired results , be sure to represent all the "variations" you want covered in the sample data. Click GO ADVANCED and use the paperclip icon to post up your workbook.
user's latest post:
Auto-insert rows &...
Published (2009-11-25 22:47:00)
Hello Brendon, This is a large workbook with a complex layout. You will not receive a solution in few hours for a project like this. It will probably take a day or two before someone codes a possible solution. Be patient.
user's latest post:
Speed up Script that lookups up...
Published (2009-11-20 09:12:00)
hi 65,000 rows is a lot of rows for Sumproduct to evaluate. Does your file actually have data in all these rows? If not, I recommend including the below code in a normal module: Code: option explicit Function LastCell(ws As Worksheet) As Range ' sourced from http://www.beyondtechnology.com/geeks012.shtml 'to identify the lastcell on a worksheet (& not necessarily the active sheet) Dim LastRow As Long Dim LastCol As Long...
user's latest post:
Concatenate cells using vba in...
Published (2009-11-24 11:38:00)
Hi, Please note the forum rules about meaningful titles. I have changed it for you as this is your first post. with Joe in A1, Bloggs in B1 and the email in C1, use Code: =A1&"."&B1&"@"&RIGHT(C1,LEN(C1)-FIND("@",C1)) Rgds
user's latest post:
Stop calculations
Published (2009-11-25 12:17:00)
I would recommend it, personally, if you want to ensure your workbook is accurate.
user's latest post:
problems with hyperlinks linking...
Published (2009-11-25 22:58:00)
There are only 37 Worksheets in your example, Column A needs to be cleared before you run the rest of the code.
user's latest post:
Compare sheets
Published (2009-11-25 22:05:00)
Hi moutoncito I was browsing this evening and remembered your post. If you haven't found a solution, look at this http://www.cpearson.com/excel/MergeListsToDistinct.aspx and see if it might have application to your issue. John
user's latest post:
Calculate working hours.
Published (2009-11-25 21:54:00)
use =G2-F2 and format the result with custom format h "Hr:" mm "Mins" Or, if you want hour and minutes in differnt cells, use =HOUR(G2-F2) =MINUTE(G2-F2) hth
|
|
|
|
Latest active threads on Excel Programming::
Started 2 days, 5 hours ago (2009-11-25 12:55:00)
by Palmetto
It would help if you upload a sample workbook that duplicates the sheet structure and includes some data (don't need all ten sheets).
It would be best, IMO, if you consolidated the data into one worksheet as this would vastly simplify the task.
Started 2 days, 6 hours ago (2009-11-25 12:06:00)
by solnajeff
Hi
If there is a space in a sheet name you need the name to have single quotes in order to work.
Change the line of code in your workbook that starts with sname to
Code:
sName = "'" & wsht.Name & "'" & "!A1"
this adds the single quotes and it works okay.
regards
Jeff
Started 2 weeks, 2 days ago (2009-11-10 20:45:00)
by JBeaucaire
Hi Brendon. Based on your explanation, I do think VBA will be the only way to get that going on.
To help you, we'll need a full set of example data sheets showing before/after/after...as many sample sheets as required to visually demonstrate all your needs.
Click GO ADVANCED and use the paperclip icon to post up your workbook.
Started 1 day, 19 hours ago (2009-11-25 22:23:00)
by protonLeah
Code:
Option Explicit
Sub Parse()
'JBeaucaire (11/11/2009)
'Based on column C, data is filtered to individual sheets
'Creates sheets and sorts alphabetically in workbook
Dim LR As Long, i As Long, MyArr
Dim MyCount As Long, ws As Worksheet
Application.ScreenUpdating = False
Set ws = Sheets("total students")
ws.Activate
...
Started 1 day, 23 hours ago (2009-11-25 19:14:00)
by rylo
Hi
This makes a couple of assumptions, but see if it is getting close to what you want.
Code:
Sub aaa()
Dim OutSH As Worksheet
Set OutSH = Sheets("Sheet3")
OutSH.Cells.ClearContents
'compare sheet1 with sheet2
Sheets("sheet1").Activate
For Each ce In Range("A2:F" & Cells(Rows.Count, "F").End(xlUp).Row)
Set findit = Sheets("Sheet2").Range("A:F").Find(...
Started 2 days, 4 hours ago (2009-11-25 14:12:00)
by munkee
Started 1 day, 20 hours ago (2009-11-25 21:54:00)
by teylyn
use
=G2-F2
and format the result with custom format
h "Hr:" mm "Mins"
Or, if you want hour and minutes in differnt cells, use
=HOUR(G2-F2)
=MINUTE(G2-F2)
hth
Started 1 week ago (2009-11-20 13:23:00)
by adam2308 Forum Contributor
Please Register to Remove these Ads
I have a form with various textboxes and combo-boxes and a command button to enter the details into some cells.
What is the best way of writing some vba code to check all textboxes and combo's are entered before carrying on with entering the data. If any details are not entered then a message box should show and take the user...
Started 2 days, 3 hours ago (2009-11-25 14:54:00)
by mrice
Maybe you need just...
Code:
With Range("Start")
For i = 1 To CountReferences + 1
.Offset(i, 0) = Application.VLookup _
(WatchesReferenceStart, Worksheets("Sheet1").Range("A: B"), 2, 0)
Next i
End With
|
|
Hot threads for last week on Excel Programming::
Started 1 week, 1 day ago (2009-11-19 15:14:00)
by losmi8
Also, IF A=Mike and B=Tel instead, then I wouldn't want to multiply C and D. I would like the code to skip that row and continue searching for where A=Mike and B=Fax and only then do the =C*D.
And of course, I need to add up all of the results (so all the C*D's).
If anyone needs further explanation of what I need, please say so. I know I am explaining this in a very confusing way. ...
Started 1 week ago (2009-11-19 20:45:00)
by davesexcel
Can you supply a sample workbook, so somebody can help you?
Started 1 week ago (2009-11-20 00:33:00)
by Nigel Registered User
Please Register to Remove these Ads
I have a workbook with around 350 worksheets. A column in the main sheet contains a list of part numbers which correspond to the names of the worksheet tabs. When a cell on the main sheet containing a part number is selected I would like a macro to find the corresponding worksheet, move that worksheet to the end of the row of tabs...
Started 4 days, 6 hours ago (2009-11-23 12:10:00)
by shg
I think you cannot have a range description that long.
Code:
With Union(Range(first half), Range(second half))
Started 3 days, 21 hours ago (2009-11-23 20:41:00)
by Richard Buttrey
Hi,
Yes, just declare another variable. e. g.
Code:
Dim dG20 as Double
' then
dG20 = Range("G20") + c.Offset(0, 3).Value
'and then
Range("G21") = "=" & dG20 & "/ SUMPRODUCT(--(A2:A29=""Mike""),--(B2:B29=""Fax"")) "
HTH
Started 4 days, 14 hours ago (2009-11-23 03:23:00)
by JeanRage
Hi,
I would recommend a step-by-step approach ... since you are tackling too many things at the same time ...
Try to stick to your initial deals list, which already requires the combination of an event macro to detect your 100 bp, a macro to avoid duplicates and a macro for the copy pastevalues to another sheet ...
HTH
Started 1 week ago (2009-11-20 07:11:00)
by blue-bullet Registered User
Please Register to Remove these Ads
Hi again, now i have this formula:
=COUNTIF( INDIRECT(A2&"_RES"),"Yes")
A2 refers to a cell to complete the indirect query (DCA_RES) which refers to another range in the workbook.
Now I want to have count if A2&"_INIT" is "BB" AND if A2&"RES" is "YES"
So that I get the amount of records of resolved queries (Yes) ...
Started 1 week, 1 day ago (2009-11-19 11:08:00)
by mewingkitty
Quote:
1 1343 1359 1407 1758 2040 1341
1 John, Doe Maker Chambers TeleTops x-ray 09/16/1987 2
2 1343 1345 1358 1359 1407 1418
2 Hoe, Drill NJ Nose Bleed Bruise Deck 04/23/1980 5
3 1758 2040 1341
3 Dexter, Tom NY 3
Might want to post an actual workbook instead of typing it out. As I'm sure you can see, this is not in fact what you ...
Started 1 week ago (2009-11-20 02:52:00)
by Brane Ded Registered User
Please Register to Remove these Ads
I am setting up a spreadsheet to be able to calculate loads on spread footings. The thing is the footings may be as small as a 2 x 2 or as large as a 6 x 6 or any combination inbetween so I need a coordinate system (to the nearest inch with a max of 1800 inches) to be able to assign each spread footing to a certain spot in the ...
Started 5 days, 7 hours ago (2009-11-22 11:08:00)
by Bob@Sun Bob@Sun is offline Registered User
Please Register to Remove these Ads
Hello,
I have 3 worksheets: Income; Expense; Consolidate.
In the first two sheets i am entering, by dates, quantities that are getting in and out of the warehouse.
My code copies that information in the consolidated sheet.
What I need is to make a code that Calculates the "Daily Quantities" and "Rent", based ...
|
|
Size: 314 bytes
