Search results

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

Good Afternoon, When referencing a Pivot Table, can someone tell me the difference/advantages/disadvantages between using the "GETPIVOTDATA" formula to refer to the pivot table and grab the data versus simply using a Copy and Paste Link? Thank you in advance for any assistance, leimst

Shrek shouldn't be there and was cut and pasted. I would like conditional formatting to highlight "Shrek" in order to identify the fact that it is not an option in the dropdown list.

Good Morning All, I'm struggling with a Conditional Formatting formula. I have a spreadsheet with a "Manager" column that has a dropdown in it. The problem is that often the users "Cut and Paste" their entries thereby by-passing the restrictions that the dropdown list is trying to impose. Is...

Thank you Narayan...that is exactly what I needed!!

Good Afternoon All, I have recorded a macro which I attached to a forms button but when I emailed the spreadsheet to the end user, the macro was not functional because it is saved in my Personal Macro Workbook, Personal.xlsb. Is there a way to save it to just this particular workbook so that...

Brilliant and elegantly simple! Thank you Narayank991!!!

Good evening, Surely the answer to this question is already posted out there somewhere and I am just phrasing my "search" incorrectly. Anyway, I have a spreadsheet with over 37,000 rows and want to insert a column where the first 200 rows read "P1" in column A, the second 200 reads "P2", the...

Hello, I have the following data: Date Merchant Code Amount Separate Merchant Code List 5/23/2012 5712 $25.24 4596 6/24/2012 5963 $15.21 8521 7/15/2012 2541 $12.00 2541 8/6/2012 8512 $32.65 3657 7/6/2012 7532 $56.45 1254 4/22/2012...

Still having trouble getting this to run...I must be setting my range incorrectly or something. Leimst

Hello, I am comparing 2 columns row by row attempting to identify where values in any given row do not match. I wanted to use conditional formatting and the formula "=A2<>B2" through the end of the spreadsheet, e.g. "=A100<>B100" so that Excel would highlight in red those rows...