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 on
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
bangmysore
jan 645 978
feb 645
mar978
it should be realigned like below: no of row
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
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(states) contains like PAK,
ENG, AU, NZ etc.,(In t
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
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 for
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. whenever
Thanks a lot Dilip,
Sure going forward will attach group in the mails.
On 12 May 2010 15:29, Dilip Pandey wrote:
> Dear Vinu,
>
> Attached file is re-formulated as per your criteria. Please get back in
> case of any help.
>
> Suggestion:- Please include "Group" i
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,10,10 instead of 10,30,40
If I need10,30,40 like this how do I get it?
Reg
Thanks a lot for your solution. I got it..
Regards,
Vinu.
On Apr 24, 9:28 pm, Harsh Gharpure wrote:
> For the data range you have specified, following is the solution:
>
> A B C (formula)
>
> 25 0 -100 2 -> =
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 Co
Hello Team,
I got the code here http://www.atlaspm.com/faqxlselfclose.html
could you please edit the same as to ful fil my requirements below.
And it should pomp up msg box at 45 min sayin "This test will over in
15 min" lik that.
Thanks.
Vinu
vinu wrote:
> Hello Friends,
>
&
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 &
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
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 al
Hi Paul,
Thanks a lot Paul.
Its working amazing!!
Regards,
Vinod.
On Apr 12, 11:18 pm, paulwillekens
wrote:
> Here it is...
>
> Greetings,
>
> Paul Willekens
> '===
> Sub GetCenters()
>
> Dim cLevel1
> Dim cLevel2
> Dim cLevel3
.
Regards,
Vinod.
On Apr 9, 11:29 pm, paulwillekens
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 = "Re
. 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 Frnds,
I explained the problem in the attached sheet only. Pls look into the same
and reply me.
Pls send it vinu1sm...@gmail.com
--
Regards
Vinod Kumar
--
--
Some important links for excel users:
1. Follow u
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
(¨`*.*´¨)¸.*´ Smi
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 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 to rite a long
Hi Hari
I am not able to see that attach option while replying don know
why/??. I always replying my gmail.
On Feb 19, 8:54 am, hari kumar wrote:
> Hi Vinu,
>
> When you are replying there will be an option "attach a file", select your
> attachment.
>
> regards
>
Hello Group members,
Could you pls let me know how to attach the file while replying to any
of the queries.
Thanks
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to exc
Hi Pooja,
You can use vlookup aswell Match index formula also. Just look into the
below solution and let me know.
--
Vinu
(¨`*.*´¨) Always
`*.¸(¨`*.*´¨) Keep
(¨`*.*´¨)¸.*´ Smiling!
`*.¸.*´
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
y
> 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 wrote:
>
>
>
>
>
> > Yes I have tried.. its no
ort Supervisor(HP)
> 91-08-99728 10886
> Email :naveenkumarmn...@yahoo.com
>
> Best Wishes-Karunaada Kuvara
>
> --- On Mon, 1/19/09, vinu wrote:
>
> From: vinu
> Subject: $$Excel-Macros$$ Re: How to unhide the sheet
> To: "MS EXCEL AND VBA MACROS&quo
its not working I tried it..
On Jan 17, 2:34 pm, "vijender kumar" wrote:
> Just go to
>
> Fomat > sheet > unhide the sheet.
>
> On 1/16/09, vinu wrote:
>
>
>
>
>
> > hello frnds,
>
> > Whenever I open Excel new file(2003) I can see
hello frnds,
Whenever I open Excel new file(2003) I can see only sheet 1 and 3,
sheet 2 is hidden. I tried to unhide by using Menu.
It didnt work. Even I open the VBA and seen sheet 2 named as and
invisible, I can make changes here and saved it.
Even though when I open a new file I cant se
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 you
. Its just
a reverse function.
Regards,
Vinu.
On Nov 25, 9:46 am, "vaibhav joshi" <[EMAIL PROTECTED]> wrote:
> hello everybody
>
> is it possible to keep few cell in a woksheet protected with password
> without alteration of that particular cell,because i dont want to
i all,
>
> I have explained all in the below attchment pls lookinto this and give your
> solution.
>
> Thanks and Regards,
> Vinu(¨`*.*´¨) Always`*.¸(¨`*.*´¨) Keep (¨`*.*´¨)¸.*´
> Smiling!`*.¸.*´_
> Net y
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
http://www.ex
gt; Sent: Friday, 31 October, 2008 5:50:41 PM
> Subject: $$Excel-Macros$$ How to findout Duplicate items
>
> Hello All,
>
> Could you pls help me out in the below issue.
>
> I have 50 amounts in a single column, those are repeated amounts.
> I would like to k
ll,
>
> Could you pls help me out 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
>
> (¨`*.*´
ld be able to double click directly 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 wi
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]>
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-m
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
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
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 to
41 matches
Mail list logo
