Search results

Hello Team, we are looking to build a kind of 'google form' based on excel or any other tool (I do not have much technical knowledge). to collect certain data from internal employees and all the inputs should be recorded in any database. Can you please suggest, which is the right tool to use...

Hello Team, I have scenario need your vba expertise to build this. Sumamry : The input data file need to be split by coulumns and create pivot table and details in a seperate sheet for each paring of the column data and save it in a folder. Details Input file : enclosed the copy, would...

Hello team, Could you please help me for the below scenario: Need a code to copy paste column data under one column and keep the same description. A B C bang mys jan 645 978 feb 645 mar 978 it should be realigned like...

I need formula for 2 of my scenarios: I have 2 list of data; List 1 contains 10 customer name; list 2 contains 500 customer name. List 2 contains customer name with little change(like prefix or suffix of something eg: list 1 vodafone, list 2 vodafone ltd) Scenario 1: I need to find out in...

Hello Team, I have senario where I have 3 column data. Col1 = players name, col2 = county name, col3= scores. Now I need to find out the person of each team who scored maximum. I used array formula to find out max for each country = MAX(IF(B2:B15="IND",C2:C15)) I used index formula to...

Hello Team, How do I use advanced filter in vba code. code should select all the data and put advance filter and conditon(i listed in sheet2 a1:d4 including heading) after filtering the same it should delte the same filtered rows by visible cells (make sure it should not delte the heading)...

Hi Team, Hello Team, I need code on the below scenario: I have data dump which contains 15 columns of data. I need code to perform the below steps: Col A(Region), Col D(country), Col J(comments). For eg: I filter the Col A (Region) by "ANZ". Then column D(country) contains like PAK...

I have a data in 2 column 1column = Region and 2nd column = country. eg: Region = ANZ, ANZ, ANZ, ANZ,GC,ANZ,GC... country = AU, NZ,IN,PAK,CN ,AU,NZ.... when I given a condition like below to pick only AU and NZ in ANZ region it works perfectly. Region Country ANZ AU ANZ NZ I...

Hello all, Need a code to perfrom the below task. I have one excel file with many sheets. Macro should ideally move particular sheet to new work book and save it in desktop. while moving it should check 2 conditions. In this file I have two drop down in c1 and d1 cells. In c1 drop down...

I have 2 sheets. In one sheet I have a series of Invoice No. in A column and company name in B column. Comp names repeated many times. In the 2nd sheet I want a formula something like this. In one cell I will mention company name and in other cell mention the any no* I need to pick up the...

Hello, I have 2 sheets. In one sheet I have a dump data where I will filter based on requiremets. In the second sheet I used subtotal formula to get some fields some. For eg. In sheet1 I have country names coloumns. whenever I filter on any country I should get that country name in the 2nd...

Hello, I have a data in two colums like A 10 B 20 A 30 C 15 D 20 B 25 A 40 If I use Vlookup will get for lookup up value"A" - it will pick up corresponding first occurance only ie,10 instead of 10,30,40 If I need like this how do I get it? Regards, Vinu.

Hello Frnds, I have a data like this: columnA -Data & column B- range & column c- Data in Range(Need formula for this), Please help me a formula to get the answer in column C. A B C( Need a formula to count the col A data tat falls in B Col range) 25 0-100...

Hello Friends, I build a model for Excel Test, Its having 3 sheets. sheet1-- Instructions sheet2-- Test Question sheet3--- Data for the Test question. Once if a candidate click on the Hyper link (which is in sheet1 - this will take to test question sheet i.e., sheet2), It should...

Hello Friends, I need a Macro code which should do the below function in the opened workbook. Please help me out: # Go to each sheet and convert as PDF file and save the same in the same path. PDF file should be named as "B1" cell content in the worksheet. # The above function shuld...

Hello Team, I enclosed the link(for file) below, I explained the problem in the "Raw Data" sheet.I need the solution like "Result sheet". Could you please give me solution for this by using any lookup formula or Macro. Link for the file - example.xls...

Hello Frnds, I am using 2007 excel. My file size is 21 MB. I used sumifs formulas extensively in each sheet(total 25 sheets). My problem is whenever I open the file or close or calculate or save it takes much time say 20 min. Would like to make my workbook faster. Could you please guide...