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