Dear Experts,
Macro Required for attached excel . this is urgent. pl help.
Process
1 Test Location name to be filled
2 Lat/Long to be taken from raw input-rsrp sheet from Yellow marked line
3 PCI to be taken from raw input-rsrp sheet data should be taken between
yello marked line
4 Test start tim
Hi Vaibhav,
Can You refer any good article where I can understand how to use the
Debugger in VBA ?
On Fri, Feb 6, 2015 at 2:20 PM, Vaibhav Joshi wrote:
> Hi Kanwaljit
>
> Any luck?
>
> On Thu, Feb 5, 2015 at 5:06 PM, Vaibhav Joshi wrote:
>
>> yes, you an do it...
>>
>>
>>
>> On Thu, Feb 5, 201
Dont know about Superman but I m definitely Salman Khan's fan !! ;)))
Cheers!!
On Sun, Feb 8, 2015 at 10:00 PM, B Sharma wrote:
> Hii Vaibhav,
>
> Happy to know that you are a CA too. That means you are a superman in
> accounting line. Because if a person is qualified CA and have good hands on
Hii Vaibhav,
Happy to know that you are a CA too. That means you are a superman in
accounting line. Because if a person is qualified CA and have good hands on
excel/vba, that means he can do 8 hrs work in just 1 hr.
I am neither a CA nor a VBA expert but have good hands on excel, little bit
of
Thanks !
Any tip on how to the Debugger in VBA ?
On Fri, Feb 6, 2015 at 4:11 PM, Ashu k wrote:
> Hi Mr. Kanwaljeet,
>
> Find the attachment. See the power of VBA.
>
> And try to make this.
>
>
>
> Regards
> Ashu Kenith
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna b
Hi Mr. Kanwaljeet,
Find the attachment. See the power of VBA.
And try to make this.
Regards
Ashu Kenith
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORU
I am from Zira, District Ferozepur, Punjab
Presently residing in Sirhind, Near Chandigarh.
On Fri, Feb 6, 2015 at 3:32 PM, Ashu k wrote:
> Hi Mr. Dhunna,
>
> Where are you from..?
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join offi
Hi Mr. Dhunna,
Where are you from..?
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, li
Hi Mr. Ashu,
That's Great !
Thanks a Lot for the Encouraging Words! Definitely I want to learn VBA. Any
guidance in this regard is Most Welcome !
On Fri, Feb 6, 2015 at 3:10 PM, Ashu k wrote:
> Hi Mr. Kanwaljit,
>
> By profession I am CA and Successfully completed Phd. too
>
> You want to lean
Hi Mr. Kanwaljit,
By profession I am CA and Successfully completed Phd. too
You want to lean VBA.
Reply me, I am ready to help you personally and professionally.
Regards
Ashu Kenith
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join offici
Hi Vaibhav,
Nice to know that you are a CA !
Feeling proud that poeple in our Profession are so Proficient in other
Fields too !
I am certainly working on sharpening my VBA skills though at the speed I
would desire too. Seems I am in the right Company :)
On Fri, Feb 6, 2015 at 3:00 PM, Vaibhav Jo
By profession i am in to CA too, n it is once personal interest n desire to
learn, since VBA is magical tool for everyone & if you expand your
knowledge it can be boon to CA office.
Also believe me those not belonging to core VBA are also replying & solving
Queries at par with VBA experts..
Yes i
Hi Vaibhav, Thanks for the Concern !
I understand everyone here is engaged in some profession but even then Some
people like you spare time out of their busy schedule to help people out of
trouble. I am a CA by profession and can do some good things in Excel but
not in VBA. I tried learning VBA at
Hi Kanwaljit
Any luck?
On Thu, Feb 5, 2015 at 5:06 PM, Vaibhav Joshi wrote:
> yes, you an do it...
>
>
>
> On Thu, Feb 5, 2015 at 5:02 PM, Kanwaljit Singh Dhunna <
> kanwal...@gmail.com> wrote:
>
>> Ok Vaibhav. Even though I have very little idea about VB (Just read the
>> codes and try to unde
yes, you an do it...
On Thu, Feb 5, 2015 at 5:02 PM, Kanwaljit Singh Dhunna
wrote:
> Ok Vaibhav. Even though I have very little idea about VB (Just read the
> codes and try to understand them) I will give it a shot.
>
> On Thu, Feb 5, 2015 at 4:51 PM, Vaibhav Joshi wrote:
>
>> i want you to w
Ok Vaibhav. Even though I have very little idea about VB (Just read the
codes and try to understand them) I will give it a shot.
On Thu, Feb 5, 2015 at 4:51 PM, Vaibhav Joshi wrote:
> i want you to work on present requirement...
>
> On Thu, Feb 5, 2015 at 2:40 PM, Kanwaljit Singh Dhunna <
> kanw
i want you to work on present requirement...
On Thu, Feb 5, 2015 at 2:40 PM, Kanwaljit Singh Dhunna
wrote:
> Ok Sir, I will do that.
>
> I hope I am clear on my present question.
>
> On Thu, Feb 5, 2015 at 2:28 PM, Vaibhav Joshi wrote:
>
>> You want to learn VBA then start modifying last code w
Ok Sir, I will do that.
I hope I am clear on my present question.
On Thu, Feb 5, 2015 at 2:28 PM, Vaibhav Joshi wrote:
> You want to learn VBA then start modifying last code which i sent to you
> to accommodate it..
>
> Start & letus know when you get error..
>
> Cheers!!
>
>
> On Thu, Feb 5, 2
You want to learn VBA then start modifying last code which i sent to you to
accommodate it..
Start & letus know when you get error..
Cheers!!
On Thu, Feb 5, 2015 at 2:15 PM, Kanwaljit Singh Dhunna
wrote:
> Hi Experts,
>
> I have attached a sheet.
> I wish there could be a macro which when run
Hi Experts,
I have attached a sheet.
I wish there could be a macro which when run
--assess the website given in column A1,
--copy the value given in cell A4 in the input box
--wait for me to enter the Captcha MANUALLY (as I have learnt that it is
quite a tedious process via code)
--copy the result
Hi Experts,
I have attached a sheet.
I wish there could be a macro which when run
--assess the website given in column A1,
--copy the value given in cell A4 in the input box
--wait for me to enter the Captcha MANUALLY (as I have learnt that it is
quite a tedious process via code)
--copy the result
Hi Experts,
I have attached a sheet.
I wish there could be a macro which when run
--assess the website given in column A1,
--copy the value given in cell A4 in the input box
--wait for me to enter the Captcha MANUALLY (as I have learnt that it is
quite a tedious process via code)
--copy the result
Hi
Chekc this attachment, press Apt + F8 and click on Macro1 to run macro.
On prompt select range B2:B15 for this data & you will get output on output
sheet..Make sure you empty column A in output sheet before running macro
else your all data will get deleted bu macro from output sheet..
Cheers
Any update plz
On 20-Jan-2015 5:22 PM, "Rakesh" wrote:
> Hi Experts,
>
>
>
> Please help to provide macro of above mentioned requirement.As in
> attached sheet On Left side i have shown the input which we have to
> fetch in macro which can range from 1 to 50. We need to select values from
> inpu
Hi Experts,
Please help to provide macro of above mentioned requirement.As in attached
sheet On Left side i have shown the input which we have to fetch in macro
which can range from 1 to 50. We need to select values from input which are
above number 5 i.e. from 6 to 50. This input data should
Hi
Try this...
You need to mention your actual sheet names & work book name along with
path in VB module..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Tue, Nov 25, 2014 at 1:02 PM, Sara Lee wrote:
> I have a excel file which has 3 tabs by name A,B
Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Sara Lee
>To: excel-macros@googlegroups.com
>Sent: Tuesday, November 25,
I have a excel file which has 3 tabs by name A,B,C and then another
excel file with tab D - both the files are in server in same location.
All 4 tabs in both the files have one common column called as Chas
Can any one help me please to get a macro which can create a unique(no
duplicates) list of
14 20:27:03 +0530
>
> Subject: Re: $$Excel-Macros$$ Macro Required for Auto Increment of Month
> Cell in calculation
> To: excel-macros@googlegroups.com
>
> Hi
>
> check this, if you change value in cell A1, your formual in B1 will get
> change automatically. Cell B3 to B5 i
Hi Vaibhav,
Thanks for the idea. It works.
Regards.
Yours Sincerely,Nitin Balodi
From: v...@vabs.in
Date: Mon, 1 Sep 2014 20:27:03 +0530
Subject: Re: $$Excel-Macros$$ Macro Required for Auto Increment of Month Cell
in calculation
To: excel-macros@googlegroups.com
Hi
check this, if you change
Hi Vaibhav,
Jan total will always be in column D and so on.
Sent from my Windows Phone
From: Vaibhav Joshi<mailto:v...@vabs.in>
Sent: 01-09-2014 10:15
To: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Subject: Re: $$Excel-Ma
Hi
How excel will know the starting month & current month for which you are
calculating formula?
On Sun, Aug 31, 2014 at 3:31 PM, Nitin Balodi wrote:
> Hi Experts,
>
> I am in fix over this part of my report automation and require your help.
>
> Please refer to attached file. Description is
Cheers!!
On Sat, May 31, 2014 at 3:15 PM, Shrinivas Shevde
wrote:
> Dear Vibhav
> Good Work Very very thanks
>
> Regards
> Shrini
>
>
> On Sat, May 31, 2014 at 12:25 PM, Vaibhav Joshi wrote:
>
>> Hi
>>
>> PFA
>>
>> All data will be merged into Result sheet, with sheets name in first col.
>>
>>
Dear Vibhav
Good Work Very very thanks
Regards
Shrini
On Sat, May 31, 2014 at 12:25 PM, Vaibhav Joshi wrote:
> Hi
>
> PFA
>
> All data will be merged into Result sheet, with sheets name in first col.
>
> Cheers!!
>
>
>
> On Sat, May 31, 2014 at 11:51 AM, Shrinivas Shevde > wrote:
>
>> Dear al
Dear all
I have a macro in which there are many sheet .
I want all data of all sheet in one sheet .Columns are same in all sheet
rows are varying.
Data should be paste one below another.
Thanks in advance
--
Shrini
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=T
This is really cool...
Cheers!!
On Sun, May 11, 2014 at 10:24 PM, Bé Trần Văn wrote:
> TEAR SHEET: Press the button "Separation sheet and name".
>
> ELIMINATION OF SHEET: Press the button "Delete sheet detached".
>
>
>
>
>
> 2014-05-07 14:12 GMT+07:00 Shrinivas Shevde :
>
> Very very thanks
>>
TEAR SHEET: Press the button "Separation sheet and name".
ELIMINATION OF SHEET: Press the button "Delete sheet detached".
2014-05-07 14:12 GMT+07:00 Shrinivas Shevde :
> Very very thanks
>
>
> On Wed, May 7, 2014 at 11:27 AM, Vaibhav Joshi wrote:
>
>> Hi
>>
>> Yes you can paste data in mast
Very very thanks
On Wed, May 7, 2014 at 11:27 AM, Vaibhav Joshi wrote:
> Hi
>
> Yes you can paste data in master file below the existing data. However you
> can test data.
>
>
> Thanks
>
>
> On Wed, May 7, 2014 at 11:25 AM, Shrinivas Shevde
> wrote:
>
>> Dear Vaibhav
>>
>> Really nice and lots
Hi
Yes you can paste data in master file below the existing data. However you
can test data.
Thanks
On Wed, May 7, 2014 at 11:25 AM, Shrinivas Shevde wrote:
> Dear Vaibhav
>
> Really nice and lots of thanks
> Small query.I will get data on daily basis as i said earlier so shall i
> copy paste
Dear Vaibhav
Really nice and lots of thanks
Small query.I will get data on daily basis as i said earlier so shall i
copy paste data below the current data in data sheet.
Regards
Shrinivas
On Tue, May 6, 2014 at 11:19 PM, Vaibhav Joshi wrote:
> Hey
>
> Check out this..
>
> Cheers!!
>
>
> On M
Dear sir,
Thanks for reply but I want perfectly opposite.
Thats I have a master sheet and from that it should go to indivisual sheet.
Regards
Shrinivas
On Mon, May 5, 2014 at 8:10 PM, Bé Trần Văn wrote:
> Reference File.
>
> 2014-05-05 17:21 GMT+07:00 Shrinivas Shevde :
>
>
>> Dear all
>>
>>
Dear all
I am getting a data on daily basis.In which there are various items and
items code.Item code is changing on daily basis.I have to make itemwise
sheet an dneeds to copy paste the items code.
Is it possible to write a code so that wheneve i clicked on a button all
items code wil go to corre
2" in sheet2
>>
>>
>>
>> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>> On Behalf Of Prafull Jadhav
>> Sent: Wednesday, February 26, 2014 3:08 PM
>> To: excel-macros@googlegroups.com; excelvbacli...@googlegroups.com
>> Su
oglegroups.com; excelvbacli...@googlegroups.com
> *Subject:* $$Excel-Macros$$ Macro Required
>
>
>
> Dear All,
>
> Good After Noon,
>
> I require one macro for attached excel sheet.
>
> Appreciate cooperation expected from you.
>
>
>
>
>
> Regards,
ups.com; excelvbacli...@googlegroups.com
Subject: $$Excel-Macros$$ Macro Required
Dear All,
Good After Noon,
I require one macro for attached excel sheet.
Appreciate cooperation expected from you.
Regards,
Prafull Jadhav
9920553518
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wa
Dear All,
Good After Noon,
I require one macro for attached excel sheet.
Appreciate cooperation expected from you.
Regards,
Prafull Jadhav
9920553518
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
; *“Do all the good you can,
> >> By all the means you can,
> >> In all the ways you can,
> >> In all the places you can,
> >> At all the times you can,
> >> To all the people you can,
> >> As long as ever you can.” - John Wesley
> >&
s you can,
>> At all the times you can,
>> To all the people you can,
>> As long as ever you can.” - John Wesley
>> *-
>>
>>
>> ------
>> *From:* rushiraj patel
>> *To:* excel-macro
you can.” - John Wesley
-
From: rushiraj patel
To: excel-macros@googlegroups.com
Sent: Mon, March 18, 2013 2:18:03 PM
Subject: $$Excel-Macros$$ Macro required to send E-mails
Dear Experts,
I required a macro to send
Dear Experts,
I required a macro to send automatic emils to my sending list. some one had
posted the same long back.
rgds,
Rushiraj
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.faceb
Dear Experts,
I required a macro to send automatic emils to my sending list. some one had
posted the same long back.
rgds,
Rushiraj
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebo
I don't know exactly because I do not program powerpoint. This is an
Excel Macros grou, after all.
However it would be something like
Picture.left = (slide.width - picture.width)/2
picture.top = (slide.height - picture.height)/2
It may need ActiveWindow.width rather than slide.width
hth
Regar
my requirement is pending please help...
On Mon, Sep 24, 2012 at 12:34 PM, Manoj Kumar wrote:
> Dear Expert,
>
> i am making my presentation, i use macro to do same size of all picture
> after i want all picture show in center of slide...
>
>
> Please help me..
>
> Sub PictureSizer()
> For NumSli
Hi Maries,
I have checked the file but all numbers, no formula inside ... hence, the
macro needs to do something on the data itself not to create another sheet.
The sample I provided is to show what result I want to see not meaning it
will be 2 sections of the data, I guess using formula will n
Hi Tony,
I have done by formula... Just check the sheets cells. There is no Macro
codes inside.
Regards,
MARIES.
On Mon, May 7, 2012 at 5:13 PM, Tony Wu wrote:
> Sorry ... I didn;t see the Macro in the attachment.
> thanks,
> Tony
>
>
> On Saturday, May 5, 2012 9:23:46 AM UTC-4, Maries wrote:
Sorry ... I didn;t see the Macro in the attachment.
thanks,
Tony
On Saturday, May 5, 2012 9:23:46 AM UTC-4, Maries wrote:
>
> Hi,
>
> Check the attachment.
>
> Regards,
>
> MARIES.
>
> On Fri, May 4, 2012 at 12:27 PM, Tony Wu wrote:
>
>> Hello,
>>
>> I have a file for the forecast demand, so
Hi,
Check the attachment.
Regards,
MARIES.
On Fri, May 4, 2012 at 12:27 PM, Tony Wu wrote:
> Hello,
>
> I have a file for the forecast demand, some parts have substitution, what
> I need is if the part has substitution, the original demand will be added
> to the new part and original dema
Hello,
I have a file for the forecast demand, some parts have substitution, what I
need is if the part has substitution, the original demand will be added to
the new part and original demand will be zero out, please see the attached
file for reference.
Thanks,
Tony
--
FORUM RULES (986+ memb
Krishnamoorthi
Sent: Jan/Fri/2012 01:41
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Macro required to set Userform height and width as
per the system monitor height and Width.
Hi Team,
I am New to this forum. I have a problem in my newly created macro in my
office.
As per the system screen
Hi Team,
I am New to this forum. I have a problem in my newly created macro in
my office.
As per the system screen size I have developed a userform for my
requirement. But the other user who has supposed to be used this tool
has having different monitor size.
Now I request you to provide me a co
Any progress from any member awaiting
On Wed, Feb 16, 2011 at 1:52 AM, maulik desai wrote:
> Hi Group,
>
> I JUST want Macro instend of Formulas used in sheets
>
> I want a macro which can give me the output like formulas (i dont want to
> use formulas in sheets as it becomes very heavy f
Dear Group,
I have excel sheets containing sales data on daily basis (from about 150
sites) (The columns are similar in all the daily sale files but rows change
from time to time as new sites either become operational or stop working). I
wish to consolidate all the data in one excel file in such a
On Apr 27, 2:41 am, Swapnil Palande wrote:
> Hi Rupin,
>
> Please find attached excel for solution. Select the range and press Ctrl and
> Q.
>
> Regards,
>
> Swapnil.
>
> On Mon, Apr 26, 2010 at 2:59 PM, Rupin Goel wrote:
Thank you for your help. It seems someone was asking the same
question
Hello Group,
I need a macro to fill the data in the attached sheet. What I want is to
fill the vacant cells below cell A4 with the value present in cell A4 till
the next valued cell . i.e. as per the attached sheet, I want the value in
A4 to be copied till cell A15, then the value in A16 to be
Hi All
I am an excel user with negligible knowledge if VBA codes.
I want to know if following is possible by any generic macro:
-->My objective is to consolidate few number of files (say 20 files) where
data is there in just two fields i.e "Country" and "Sales in USD". To
clarify more: There
65 matches
Mail list logo