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
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 v...@vabs.in wrote:
Hi Kanwaljit
Any luck?
On Thu, Feb 5, 2015 at 5:06 PM, Vaibhav Joshi v...@vabs.in wrote:
yes, you an do it...
On Thu,
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
Dont know about Superman but I m definitely Salman Khan's fan !! ;)))
Cheers!!
On Sun, Feb 8, 2015 at 10:00 PM, B Sharma sharma@gmail.com 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
Thanks !
Any tip on how to the Debugger in VBA ?
On Fri, Feb 6, 2015 at 4:11 PM, Ashu k direct2as...@gmail.com 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
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
I am from Zira, District Ferozepur, Punjab
Presently residing in Sirhind, Near Chandigarh.
On Fri, Feb 6, 2015 at 3:32 PM, Ashu k direct2as...@gmail.com 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
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,
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
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
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
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 direct2as...@gmail.com wrote:
Hi Mr. Kanwaljit,
By profession I am CA and Successfully completed Phd. too
Hi Kanwaljit
Any luck?
On Thu, Feb 5, 2015 at 5:06 PM, Vaibhav Joshi v...@vabs.in 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
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
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 understand them) I will give it a shot.
On Thu, Feb 5, 2015 at 4:51 PM, Vaibhav Joshi v...@vabs.in
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
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 kanwal...@gmail.com
wrote:
Hi Experts,
I have attached a sheet.
I wish there could be a macro
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 v...@vabs.in wrote:
i want you to work on present requirement...
On Thu, Feb 5, 2015 at 2:40 PM, Kanwaljit Singh
i want you to work on present requirement...
On Thu, Feb 5, 2015 at 2:40 PM, Kanwaljit Singh Dhunna kanwal...@gmail.com
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 v...@vabs.in wrote:
You want to learn VBA then
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 v...@vabs.in 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
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
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
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..
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
Any update plz
On 20-Jan-2015 5:22 PM, Rakesh rksharma...@gmail.com 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
lee.sar...@gmail.com
To: excel-macros@googlegroups.com
Sent: Tuesday, November 25, 2014 2:32 AM
Subject: $$Excel-Macros$$ macro required for finding uniques
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
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 lee.sar...@gmail.com wrote:
I have a excel file which has
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
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
: $$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 is just for explanation, which you can
delete.
Cheers!!
On Mon, Sep
Hi Vaibhav,
Jan total will always be in column D and so on.
Sent from my Windows Phone
From: Vaibhav Joshimailto:v...@vabs.in
Sent: 01-09-2014 10:15
To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro
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 nitinbal...@live.com wrote:
Hi Experts,
I am in fix over this part of my report automation and require your help.
Please refer to attached file.
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
Dear Vibhav
Good Work Very very thanks
Regards
Shrini
On Sat, May 31, 2014 at 12:25 PM, Vaibhav Joshi v...@vabs.in 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
Cheers!!
On Sat, May 31, 2014 at 3:15 PM, Shrinivas Shevde shrinivas...@gmail.com
wrote:
Dear Vibhav
Good Work Very very thanks
Regards
Shrini
On Sat, May 31, 2014 at 12:25 PM, Vaibhav Joshi v...@vabs.in wrote:
Hi
PFA
All data will be merged into Result sheet, with sheets name in
This is really cool...
Cheers!!
On Sun, May 11, 2014 at 10:24 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote:
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
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 shrinivas...@gmail.com:
Very very thanks
On Wed, May 7, 2014 at 11:27 AM, Vaibhav Joshi v...@vabs.in wrote:
Hi
Yes you
Very very thanks
On Wed, May 7, 2014 at 11:27 AM, Vaibhav Joshi v...@vabs.in 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
shrinivas...@gmail.comwrote:
Dear Vaibhav
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 betnmtdongna...@gmail.comwrote:
Reference File.
2014-05-05 17:21 GMT+07:00 Shrinivas Shevde
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 v...@vabs.in wrote:
Hey
Check out this..
Cheers!!
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 shrinivas...@gmail.comwrote:
Dear Vaibhav
Really nice and lots of thanks
Small query.I will get data on daily basis as i said earlier so
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
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 @
...@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 wanna be? It's
=TIME(2
...@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 wanna
[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
Subject: $$Excel-Macros$$ Macro Required
Dear All,
Good After Noon,
I require one macro for attached excel sheet
,
As long as ever you can.” - John Wesley
*-
--
*From:* rushiraj patel rushiraj2...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Mon, March 18, 2013 2:18:03 PM
*Subject:* $$Excel-Macros$$ Macro required 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 @
can.” - John Wesley
*-
--
*From:* rushiraj patel rushiraj2...@gmail.com
*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 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
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 wumu...@gmail.com wrote:
Hello,
I have a file for the forecast demand,
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 wumu...@gmail.com wrote:
Sorry ... I didn;t see the Macro in the attachment.
thanks,
Tony
On Saturday, May 5, 2012 9:23:46 AM UTC-4,
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
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+
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
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
On Apr 27, 2:41 am, Swapnil Palande swapnilp1...@gmail.com 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 rupin.investm...@gmail.comwrote:
Thank you for your help. It
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 are
60 matches
Mail list logo