Search results

Hi All I was working on complex calculation project, where i was confused on logic to be used. I have matrix which is in Table Like below (Table 1) Roles Col A Col B Requester Admin Finance Requester Finance Requester Basically i am comparing a list users with this table...

Hello everyone I am stuck with a excel file. I have a excel file which i am downloading from one software. Its basically logs file, i mean which all users logged in and their activity. What i am trying to do is, i have possible sentence which will not matches exactly but partially it matches...

Hi I think we can't do date range in Pivot and for two tables we can't have one category filter for two tables. Is that possible to do, if not can we do same two table in VBA? I will get huge data that time i can't do manually

Hi Everyone I am stuck with one report, basically i was trying to add pivot table for sale report. I need 2 tables, one is category report, by adding Category and Date in filter and second one is Top 10 sales , by adding Category and Date in fitter. Both i did it in attached file. But is that...

Any suggestion would be great....

Hello all I have 2 workbooks, From my macro file i am trying to open one work book, copy all rows and paste into another workbook. Current problem is , i have around 100,000 records. Its taking lot of time with current macro. and also screen will freeze. Is there any way to improvize below...

Thanks Charlesdh. Unfortunately i need data validation for that. The file you sent will do filter and paste to respective sheet and column.

Hi Ramana You can use Sum Product. I have updated in the attached file. =SUMPRODUCT(($C$2:$Q$2=C14)*($B$3:$B$9=B14)*($C$3:$Q$9))

@Kenshin try Sumifs...

Any Suggestion would be appreciated...

Hello All I have a requirement which i am doing in VBA. I have sheet called Drop downs, where i have 5 columns, Sheetname, Catergory, Column name, Sub category, Column Name. Now, macro has to go Drop down sheet, and filter each sheet name, eg : if sheet name KPI1, then it has to copy all...

Hello All I have a requirement in excel macro. I have 2 workbooks, Say A and B A Workbook contains, sheet 1, sheet2 and sheet3 B Workbook contains sheet4 Now i need to compare 2 workbooks, if missing sheets in Workbook B, then need to add sheets from Workbook A So finally, B workbook...

I Its working. thanks a lot :)

Hi Vletm Code worked, is there a way to highlight row where mail not been sent. I have attached my file. where i can see mail sent for first row, instead of tracking one by one, can we highlight?

Hi All I have written code which will send mails. Unfortunately for some rows mail address will not be in correct format, for those email, outlook will throw some error like "Outlook doesn't recognize one or more names" and macro will stops running. Is there any way to highlight that rows and...

Vletm Its correct file. Just now checked again... column C will have email address, for every user we will add "@gmail.com" at the end.

Hello All I have an excel sheet, i need to go each row and to check if exception 1 and exception 2 column is "NO". If its no then , i need to copy subject in Column M, and search in Outlook mails, if mail already sent, if sent then reply all with one table which is in excel workbook. If mail...

Hi Everyone I have macro code written workbook, which contains sheet called "Teachers List". For each teachers have multiple students and have templates. I need a macro which will generate new workbook for each teachers and need to copy template from main workbook and paste in new workbook for...

Thanks it worked.

Hello All I am working on Excel file which have 2 sheets, first and second sheets with 4 columns. I want to concatenate 4 columns in a order "Amount", "Name", "Country" and "Bill No". Once done, I want to compare these 2 columns, if i found opposite sign value with same values, then i have to...

Hi All I need some help on complex excel data. Here is the scenarios: I have excel data with 3 columns, (Id, Amount and Error Code). I will get 3 types of error code 1, 16 & blank. I have to go each error code and do the following things. If Error Code 1: I have to group Id and sum up the...

Excellent Shrivallabha, its working perfectly. No words. Superb. Once again Thanks.

Hi Vletm Ok, Here is the scenario. I have SAP application, From that i will get raw data which will be in .xlsx format. From that i cannot insert macro, so i have created new Excel macro enabled file. there will be 2 sheets one is Input and second one is Output. So, what i have done manually...

Hi Here is the raw file that will get from one application. It will be in .xlsx format. I will copy data from CH sheet and paste to my macro file to run and generate output in Output sheet.

Hi I am confused, i already attached the raw file in my original post. (Input sheet is my raw file, that i am getting from one software). I want to delete blank rows and columns and final out put like in sheet Output. Please let me know.