Recent content by leimst

Thank you Bosco, that worked perfectly...brilliant! leimst

Good Morning All, In the attached below, I would like to make the table on the left look like the table on the right by having a formula that looks in Column A and finds "Hershey's Total", extracts "Hershey's" and places it in C2-C5 leaving C6 blank. Then the formula would extract "Nestle" from...

Hello, I am looking for VBA code that would find the blanks in the QBRat column and delete those entire rows, e.g. Matt Ryan and Matt Cassel and then find the last row in the spreadsheet and calculate the Pct column down to through that last row. (Comp / Att * 100 = Pct). Thank you in advance...

Sorry, I meant to post this in the VBA forum! Ignore this and I'll post it over there. Thnx, leimst

Hello, I am looking for VBA code that would find the blanks in the QBRat column and delete those entire rows, e.g. Matt Ryan and Matt Cassel and then find the last row in the spreadsheet and calculate the Pct column down to through that last row. (Comp / Att * 100 = Pct). Thank you in advance...

Mahir, thank you for your explanation. I now see why I did not understand. I asked for the update on the New tab to be "automatic"...no manual intervention. Consequently, bobhc's solution will not work.

Thanks azumi!

Help! Can anyone explain to me how Bob accomplished this? I guess I was expecting to see an Offset, or Index formula perhaps but I'm not seeing any formulas or macros. I wanted to add records to the Source tab and have the New tab update automatically. Is this possible? Again, thanks for any...

bobhc, I'm afraid I'm not seeing how this works? I see that you have added entries to the Source tab and that they are reflected on the New tab but when I add more records to the Source tab the New tab is not updating? Thanks, leimst

Hello, I have a source sheet with data. I would like to create a new sheet that would utilize certain columns from the source file and I would like this new sheet to update automatically as new entries are made on the source sheet. Is there an easy way to do this? I have attached an example...

Thank you Patnaik, that worked great! leimst

Hello, I have never used VBA before so I am totally unfamiliar. I am looking for VBA code that would find certain text and replace it using a reference table so that the code knows what to replace the original text with. I have attached an example doc where the "Reference" tab provides a table...

That worked great! Thanks Narayan!

Hello, I have a column of first names and middle initials. What formula could I use to extract the first name only? Thank you in advance for any assistance, leimst

Thank you Narayan. That is a much needed insight! I was finding Copy and Paste Link to be a little quicker and easier but from your explanation I can see that GETPIVOTDATA is worth the little bit of extra effort! Thank you!! leimst