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...
Thanks for your answer. Where as I need formula to enter infront of List2 not in List1.Eg:countif(range1,range2).
And in 2nd scenario I need to list out the reapeted with little change customer names.
Thnx.
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...
Hi PSG,
I am using 2007 only, its not working. But I got the solution condition should be :
ANZ <>AU <>NZ
should not write below,
Thanks
VInod.