Search results for query: *

The table is repopulated by copy/paste. The origin data is an output from a program that creates a .csv file in a year\month\week directory structure.

Thanks Skip. That is a great solution. The table you have labeled tMain is a data set that is repopulated each week. Considering that, I would need to create and populate the Group column each time and I assume re-create the sumproduct formula since the cell reference would convert to N/A once...

Gavona, Thanks for the reminder. I don't usually forget. Skip, You may have assumed incorrectly. I don't believe this is the solution, which is why I posted. My solution works, but I believe there is a better solution. I've already admitted that I tend to over-complicate at times when there is...

Thanks for your assistance Andy. Your post is helpful and very beneficial. People like you help make this community of users better.

...Select Case y Case "Level 1" y.Offset(0, 1).Value = WorksheetFunction.Sum _ (WorksheetFunction.CountIfs(subbuCol, "Asia" & "*", ordstatCol, "<>Closed", ordtypeCol, "Level 1"), _ (WorksheetFunction.CountIfs(subbuCol, "*" & "eCommerce" & char(10) & "China" & "*"...

Thanks again for help. Your created code works like a charm. I appreciate your time in doing that, as it helps me to learn. The other solution, as rudimentary as it appears, is also effective and is easier to understand for lower level users such as myself.

Just to feed my curious side, what was wrong with my initial code?

Thanks, that works. Looks like I was over-complicating it. Sub Macro1() Range("F2").Select ActiveCell.FormulaR1C1 = "=IF(RC[-4]=R[-1]C[-4],0,1)+R[-1]C" Range("F2").Select Selection.AutoFill Destination:=Range("F2:F9"), Type:=xlFillDefault Range("F2:F9").Select...

That's correct. Each worksheet has the exact same structure, but different data.

Skip, thanks again for your assistance. As indicated in my initial post, the data set is a small scale of a larger data set. I'd rather not have to take this manual step for each worksheet containing this data. This approach creates a manual process that has to be repeated multiple times a week...

The following is a small scale of a data set I have in Excel: Country State City Count Date U.S. New York Albany 200 2/4/2013 U.S. New York Albany 200 1/6/2013 U.S. New York Albany 200 12/31/2012 U.S. New York Buffalo 10 4/10/2013 U.S...

I'll repost with a more accurate description of what I'm trying to accomplish.

Thanks for your response Skip. My apologies, the columns do have headers (actually the ones you indicated). The reason I'm using VBA is because my ultimate goal is to sort 20+ ranges by two other columns - Date(E) and Status(F) everytime the report is produced. The customer for the report is...

I need to create a ranges for a data set that changes everytime a report is run. The columns are a consistent order and count. The range would be based on the value in column B. I can work with A1 or index format. Here's an example of the data: A B C D U.S. New...

Skip, I understand your reasoning, but doing it that way would be somewhat cumbersome. There's general 20 (10 pairs) columns and multiple reports/worksheets. It's the way the program exports the data to CSV that's problematic. Sorry, I didn't explain enough.

I have a worksheet that has multiple columns with similar data. The data is related by a pair of columns, so I need to search one column for a parameter then return the information on the same row in the next column. Here's a sample of the data: TYPE NAME TYPE NAME Subject Robert...

Awesome! It works! Thanks for the fix and the additional cleanup.

I'm attempting to loop through each cell in a column and complete a vlookup for each value. My syntax doesn't seem to be correct, because I get a 'run time error 1004' on the vlookup line everytime. Any help would be appreciated. Sub CalcAging() Dim aCol As Long Dim aCell As...

PHV - YES!!! Two days in a row you have made my headache go away. Thank you!

PHV - I get the same run-time error when I try that method. Skip - Well that's no fun at all :) ...that and it disrupts the larger part of the rest of my code. I was able to to copy to another sheet as long as the column didn't change with the following code: Sub Sample() Dim ws As...