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 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...

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...

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...

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...

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...

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...

Hi All I am getting unstructured data from one application. I need to delete blank rows and delete column. I have attached my input file and how i need output file. Can anyone assist me on this.

Hi All I have a excel sheet which has 4 column, i would like to delete rows based on some criteria's. My columns are Record #, Amount, Note 1 and Note 2. My Criteria will be : Some time Note 1 or Note 2 will have record #. I have attached example file, in that first row having some note 1...

I have set of excel rows, which has 2 columns, first columns is date and second column is currency. So i want to split data based on below condition. Once Currency column is greater than zero, from that row till the row which has number greater than zero and copy entire row and paste it in...

Hi All i got a macro code, which will open PDF and put a stamp in PDf. i need to add "Approved" stamp, but the macro is adding "Draft" Stamp. I have attached the vba code. Any suggestion which will add "Approved" stamp?

Second post of the day :) I found this post as tricky. so i need some assistance. I have 2 columns, first column is bill no and second column is doc no. So, i have multiple doc no with single bill no. Now, I need all unique bill in one by one row and doc no in column by column I have...

Hi all IS that possible to highlight rows based on the following. My column contains combination of "Name"&"Amount. Eg: Kiran1000 Rajesh2000 but in some cases i have Kiran-1000 So i wanted to highlight Both rows Kiran1000 and Kiran-1000. I have unique names, shown is an example. Any...

Hello to all I have an excel file which contains account # and Disp columns, Basically, Account # will have duplicate Values, 1. if it contains duplicates value then i need to check Disp column, if it contains values like "Full" and "Partial" then, leave full and cut "partial" row and move...

Hi All I have a complex excel file, which contains swipe details. I have attached sample file. i need to count the total time spent on each location, not getting any idea how we can do it. Eg: Row 3 and Row 4 having time for "10TH FLR WORK-STATION" which is 1 min, 10TH FLR MAIN-ENT which is...

Hello to all I am creating dash board, i am trying to add one extra column to pivot table which will be based on results of pivot table. i have attached the example sheet. I need to calculate percentage from total of Net Inv / Net Inv of that row. Any suggetion how we can do this.

I wanted to know, is that possible in excel, I have 2 sheets, one is database that will update daily, in that sheet Column A is Driver name. In second sheet i have unique Driver name and in second column i have entered orders of driver i needed. Say example Driver A should be in 2 order...

Hi to all I am creating macro application. I have a sheet with few columns, Below is the format of sheets. Class Subject Kiran Rahul Mary Susan X Language1 85 45 60 94 X Language2 80 40 60 95 X Maths 60 42 60 92 X Physics 45 43 60 91 X Chemistry 35 75 60 90 X Biology 60 60 60 92 I need to...

Hi I have database everything in One row, i want to split into rows, i have attached the file. there are two sheets input and output, Input contains how i am getting the data. I want output is like Output sheet. copy each 4 columns to new row. Thanks in advance

Hello i am calculating percentile of a column, using "=Percentile(column, 0.5)" But my situation here, is i have 2 columns one is country and second column is salary. I want to calculate country wise median percentile, i used below formula to calculate : =PERCENTILE(IF(A2:A6275=G6,B:B),0.25)...

Hello I have set of data in one sheet, that i need to copy paste to another sheet. I have attached the sample excel file. I have shown one example in this file. Please let me know is that possible in Excel Macro.