Search results

Yes. How did you do it?

Chihiro, I am using Excel 2016. Attached is sample data. Report i am looking for is Total sales and total transaction. one PV that sum the listing and sales by agent name.

I get a dump of real estate data and i am looking to put the data into a pivot table some the manger can look at agent production numbers. The issue is there is a "Listing" and a "Selling" agent. So I can make one table for both the listing agent and selling agent for numbers and sum and add...

Chihiro, I totally understand. Thanks again for your help. Hope your project is successful.

Chihiro, Thank you for your code, I had looked into the dictionary option, but it was a little over my head. Over the last few days I have had some time to work through your code. I have one question. How do I have the code disregard new item(s) that have been added to Update file? For this...

Narayan, Thank you...

Hui, My issue is when the code is run with data in a table structure, the code takes x10 longer then non-table structured data. Replicate the problem by going to "Run Sheet" cell B2, the pull down will show U68EL1 and U68EL1(t). Start by running U68EL1 note the duration in C2, then run...

Hui and Chihiro, Attached is my VBA code and 2 sets of data. The first set of data is not structured in a table and the second set is in a table structure. On the "Run Sheet" cell B2 you can switch between the two different formats. Also, the macro can be run from the "Run Sheet" as well...

I am using Excel 2016 and have two sheets "Base" and "Update" data. I have the data in tables for dashboard purposes. However, i have several VBA compares that I run on the data and I noticed the other day that when the data is in a table the compares take about a 1 to 2 min's to run, BUT, if...

Chihiro, Still getting the same error after added the reference you suggested, any other thoughts. Thanks for your help.

sorry using Excel 2010 on win 7 system.

The "Dim pi As Imaging.PropertyItem" is giving me a "User-defined type not defined" I am new to the VBA and coding in general. can some help me address the above error. I have pulled together some code to pull all photos in a dir. now i would like find the modify the orientation and moving...

Thanks and yes there will be times when there will be "Activity ID" in one but not the other... I will try and run it shortly...

What I would like to happen is copy the "Activity Id" for any items that have changed to a new sheet based on the type of change. So "Remaining Duration" changes will go to "Remaining Duration" Tab.

Shrivallabha, Attached is some sample data....

Deepak, Thank you for your help. My question is how to make the code work for columns A & B, as well as A & C, A & D, and A & E. Column "A" will be a constant, and second column will vary from "B" to "P" with different data types like, B = description and F = start date, to name a few. I...

I have a compare between 2 worksheets I have been using but it is very ridged. I am looking to make it less so. What the workbook is doing now is inserting a column A to sheets "Update" and "Base" that is equal to "A1"&"B1" and copied to the end of the column. Once the compare is complete the...

Thank you. Works like a charm...

Sorry I forgot to changes the tab name to "BASE" to match the code...

IsCellBlank_3 work for single date but can't get the IsCellBlank_4 to work for a worksheet. See attached sample data...

First, thanks for any and all help. I get file dumps from several different PM, with the raw data in different orders. What I have done is, converted the formatting from "dd-mmm-yy hh:mm:ss" to "dd-mmm-yy" removing the "hh:mm:ss", but, now I want to be able to to do it for a whole workbook vs...

Sub TF() Dim rng As Range Dim i As Long Dim TF As Long 'Value 'Range Set TF = Application.Match("TF", Sheets("Update").Range("1:1"), False) '.Value With ActiveSheet Set rng = .Range("A1:A" & .Cells(.Rows.Count, 1).End(xlUp).Row) For i = 2 To rng.Rows.Count rng.Cells(i, 4) =...

Tank you... Will need to work this into my file.... And again Thanks you, love this site. Every day i lean more and more i can do.

SirJB7, I am comparing the data in Base_Logic to Rev_Logic to get "Logic(Added)" and "Logic(Del). So now i wan to get the same thing for the "Logic(Mod)". I have compared [ACT]&[SUC] in each table to get the added/del, but if i added [ACT]&[SUC]&[REL]&[LAG] to the mix then they become mix...

Hi all... I have been working on this schedule compare file off and on over the last few weeks and have it to ware i need it to be for now. But, there one thing that is driving me nuts. What i am comparing is the schedule logic for added, deleted, and modified. I have the first two (2) i...