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
save it in a folder.
Details
Input file : enclosed the copy, would like to split the data based on the
country[india , china and so
Hello Team,
I need help on the below scenario.
1. I have a 50 columns of data, in this I need delete multiple entire
column(C:F, K, AA:AD)
how do I do this. I have listed all the column heading in column
which needs to be deleted - need code for this.
2. I need to delete few rows based on
Hello Group,
Does any one have vba code which move excel files from one folder to
share point folder.
I have 40 files and which i need to export to sharepoint 40 different
folders. Is there any way to do in VBA.
Regards,
Vinu
by giving the sheet name as file name.
Original file should not make any changes.
Could you please help me out. I attached the file below.
--
Vinu.
--
--
Some important links for excel users:
1. Follow us on TWITTER
Hello,
I have 2 sheets. In one sheet I have a dump data where I will filter based
on requiremets(only first colounm i.e, country is only one filter - not
multi filter). In the second sheet I used subtotal formula to get some
fields SUM. For eg. In sheet1 I have country names coloumns.
Thanks a lot Dilip,
Sure going forward will attach group in the mails.
On 12 May 2010 15:29, Dilip Pandey dilipan...@gmail.com wrote:
Dear Vinu,
Attached file is re-formulated as per your criteria. Please get back in
case of any help.
Suggestion:- Please include Group in such emails, so
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 valueA - it will pick up
corresponding first occurance only ie,10,10,10 instead of 10,30,40
If I need10,30,40 like this how do I get it?
Regards,
Vinu
Thanks a lot for your solution. I got it..
Regards,
Vinu.
On Apr 24, 9:28 pm, Harsh Gharpure hsgharp...@gmail.com wrote:
For the data range you have specified, following is the solution:
A B C (formula)
25 0 -100 2 - = countif
min it should protect and save it. Then he cant
open tat as its protected.
Regards,
Vinu.
Paul Schreiner wrote:
That's actually very tricky to do, and has all kinds of potential for
circumventing it.
The problem is that when VBA macros run, they usually have control of Excel.
they don't
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
25 0 -100 2 ( Need a formula to count the col A data
which appears in B Col
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 do it all
time
to count and should be closed in exact 60 min. Once 60 min over it
should automatically protect the workbook by giving any password and
should close.
Could you please guide me how do this.(give me code if its required)
Any suggestions are appreciated!
Regards,
Vinu
Hi Paul,
Thanks a lot Paul.
Its working amazing!!
Regards,
Vinod.
On Apr 12, 11:18 pm, paulwillekens paul.johan.willek...@gmail.com
wrote:
Here it is...
Greetings,
Paul Willekens
'===
Sub GetCenters()
Dim cLevel1
Dim
.
Regards,
Vinod.
On Apr 9, 11:29 pm, paulwillekens paul.johan.willek...@gmail.com
wrote:
Hi Vinu,
See the solution below... I created a sheet test to see the test
result... In the macro you can (after testing) modify statement
cTest = test
to
cTest = Result Sheet
Good luck.
Please
. I have some idea like:
Shall I use sumproduct instead of sumifs - sumproduct is faster than
sumifs??
shall I use Pivot table and get pivot formula to get data.
or any other ways.
Please guide me.
Regards,
Vinu.
--
Regards
Vinod Kumar
Bangalore
+91-9986423819
Hello,
I have enclosed the copy of xl sheet, hope which will clarify your
question. If you need any clarification or If am wrong please let me know.
Thanks Regards
--
Vinu
(¨`*.*´¨) Always
`*.¸(¨`*.*´¨) Keep
(¨`*.*´¨)¸.*´ Smiling
Hello Praveen,
I hope you are doing well, happy Ugadi.
I have enclosed the copy of xl sheet, which solves your query. I used
Sumproduct forulat, just change the company names to know the count.
Please let me know if you have any issues.
--
Vinu
(¨`*.*´¨) Always
`*.¸(¨`*.*´¨) Keep
Hello Puneet,
Try with ALT + Enter-- it will go to the next liine in the same
cell.
Regards,
Vinod
On Feb 18, 11:02 pm, Puneet Jain puneet...@gmail.com wrote:
Hi all
How to increase the size of cell, without using function called format cell
or shrink/wrap, bcoz what happen if u have
hide... (-1) factor.
this may clear everything...
if not... than reinstall MS Office that's the ultimate solution for your
problem.
Regards,
Viral Pandya
On 1/21/09, vinu vinu1sm...@gmail.com wrote:
Yes I have tried.. its not working..
On Jan 21, 10:51 am, Naveen naveenkumarmn
)
91-08-99728 10886
Email :naveenkumarmn...@yahoo.com
Best Wishes-Karunaada Kuvara
--- On Mon, 1/19/09, vinu vinu1sm...@gmail.com wrote:
From: vinu vinu1sm...@gmail.com
Subject: $$Excel-Macros$$ Re: How to unhide the sheet
To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
Date
its not working I tried it..
On Jan 17, 2:34 pm, vijender kumar simplevi...@gmail.com wrote:
Just go to
Fomat sheet unhide the sheet.
On 1/16/09, vinu vinu1sm...@gmail.com wrote:
hello frnds,
Whenever I open Excel new file(2003) I can see only sheet 1 and 3,
sheet 2 is hidden
Hi Could you pls send me financial and statistical analysis ebook to
[EMAIL PROTECTED]
thanks
vinod
On Nov 25, 5:45 pm, anandydr [EMAIL PROTECTED] wrote:
Hi,
If you can provide more details on what kind of ebooks you need the
books I send would be more specefic. Kindly also mention your
Hi All,
I have a data like this in a single cell for eg A1 11/4/2008
5:51:00 PM.
I need date in A2 cell and time in in A3 cell. How to do it. Plz
help me.
Thanks in advance.
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
in the below issue.
I have 50 amounts in a single column, those are repeated amounts.
I would like to know which are all repeated amounts by highlighting or
something like that.
Thanks
--
Vinu
(¨`*.*´¨) Always
`*.¸(¨`*.*´¨) Keep
(¨`*.*´¨)¸.*´ Smiling!
`*.¸.*´
Add more friends to your
Thanks a lot!!
On Oct 30, 8:26 pm, Ajay Varshney [EMAIL PROTECTED]
wrote:
=A1 B1 TEXT(C1,HH:MM AM/PM)
Use the above forlula
On Thu, Oct 30, 2008 at 11:19 AM, vinu [EMAIL PROTECTED] wrote:
How to concatenate the below one.
A1=India
B1=Bangalore
C1=12:10Am
Thanks in advance
into the
cell.
Let me know if I have missed any part of your questions.
Rgds
Sumeet
On Thu, Oct 30, 2008 at 2:10 AM, vinu [EMAIL PROTECTED] wrote:
Hello All,
I have problem with double click activation in excel.
I have data in A and C column. But if I enter 1 and 2 in B column,
select
Hi All,
Could you pls let me know how to hide and unhide only formula in a
particular cell or a sheet.
Regards,
vinu.
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email
How to concatenate the below one.
A1=India
B1=Bangalore
C1=12:10Am
Thanks in advance.
Vinu.
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros
Hello All,
I have problem with double click activation in excel.
I have data in A and C column. But if I enter 1 and 2 in B column,
select both and double click its not taking automatically, I need to
drag manually. could you pls let me how to solve this.
Regards,
vinu
Hi this works well.
How to concotenat the time formate for eg:
MS Exce 12:15 AM how to do this..
Regrds,
vinu.
On Oct 29, 9:18 am, Bhavish Poddar [EMAIL PROTECTED] wrote:
Hi use this function : =A1 B1 TEXT(C1,dd-mmm-yy)
where A1 = MS
B1 = Excel
C1 = 29-0ct-08
On Fri, Oct 24, 2008
30 matches
Mail list logo