Hi Swapnil,
Just to let you know all your comments should be based on the error code.
Error Code column
1
2
3
all these three has different error description.
Thanks
Putta
On Thu, Jul 6, 2017 at 7:14 PM, Puttu * wrote:
> Hi Swapnil,
>
> Thanks you so much appreciate your time an
l.
>
> On Wed, Jul 5, 2017 at 12:24 AM, Puttu * wrote:
>
>> anyhelp please
>>
>> On Tue, Jul 4, 2017 at 12:33 PM, Puttu * wrote:
>>
>>> Thanks Sir, Formula match exactly my requirement, however I have more
>>> than 50 columns, quite difficult to i
anyhelp please
On Tue, Jul 4, 2017 at 12:33 PM, Puttu * wrote:
> Thanks Sir, Formula match exactly my requirement, however I have more than
> 50 columns, quite difficult to input formula for every column. Thus the
> reason I am looking for macro.
>
> Please help
>
> On Tue,
t;
> No need of macro, you can do it using formulas also. Attached is the excel
> for your reference.
>
> Regards,
> Swapnil
>
> On Tue, Jul 4, 2017 at 10:36 AM, Puttu * wrote:
>
>> Experts, Any help on this will be much appreciated
>>
>> On Mon, Jul
Experts, Any help on this will be much appreciated
On Mon, Jul 3, 2017 at 10:33 PM, Puttu * wrote:
> Hi Experts
>
> Please help on this.
>
> Thanks
> Putta
>
> On Mon, Jul 3, 2017 at 9:42 PM, Puttu * wrote:
>
>> Hi Experts,
>>
>> I am not a vba
Hi Experts
Please help on this.
Thanks
Putta
On Mon, Jul 3, 2017 at 9:42 PM, Puttu * wrote:
> Hi Experts,
>
> I am not a vba expert and need your help me on the attached requirement.
>
> I have list of columns and from that I need to know based on the Model No.
> column f
Hi Experts,
I am not a vba expert and need your help me on the attached requirement.
I have list of columns and from that I need to know based on the Model No.
column filter if the other columns have any duplicate values, if yes then
it should display comments column as *Column Name + duplicate v
Hi Abhishek,
Please find the attached text file. let me know if you need any further
details.
On Sun, Jul 31, 2016 at 9:20 PM, Abhishek Jain
wrote:
> Please send your sample txt file as attachment.
>
> On Sun, Jul 31, 2016 at 6:46 PM, Puttu * wrote:
>
>> any help please :(
any help please :(
On Sat, Jul 30, 2016 at 10:19 PM, Puttu * wrote:
> Some one look and help on this please
>
> On Sat, Jul 30, 2016 at 12:16 PM, Puttu * wrote:
>
>> Experts... please please help me on my requirements
>>
>> On Fri, Jul 29, 2016 at 4:13 PM, Put
Some one look and help on this please
On Sat, Jul 30, 2016 at 12:16 PM, Puttu * wrote:
> Experts... please please help me on my requirements
>
> On Fri, Jul 29, 2016 at 4:13 PM, Puttu * wrote:
>
>> Hi Experts,
>>
>> Need a help either in macro or formula
Experts... please please help me on my requirements
On Fri, Jul 29, 2016 at 4:13 PM, Puttu * wrote:
> Hi Experts,
>
> Need a help either in macro or formula anything is still fine. Below
> format I receive a text file, but I need to all the fields to be updated in
> excel. P
Hi Experts,
Need a help either in macro or formula anything is still fine. Below format
I receive a text file, but I need to all the fields to be updated in excel.
Please advise is there any easy way to do this and let me know if you need
more info from my end
*Sample Records Input text File in t
Thank you sooo much Mandeep :) You are really the best :) thanks again
On Wed, Jan 20, 2016 at 11:13 AM, Mandeep Baluja
wrote:
> PFA !!
>
> Regards,
> Mandeep baluja
>
> --
> 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
Hi Experts,
Please help me solve this problem through VBA Macro.
Problem Statement In the Input sheet some names of the employees will be
populated in column A as shown below. The rows in which data will be
available is uncertain. Provide the output in Output sheet in column A.
First row shoul
could you please help on other assignment as well
On Tue, Jan 19, 2016 at 11:49 AM, Puttu * wrote:
> Perfect :) Thank you so much Mandeep. Appreciate your quick help
>
> On Tue, Jan 19, 2016 at 11:37 AM, Mandeep Baluja
> wrote:
>
>> Check this result of your first qu
Perfect :) Thank you so much Mandeep. Appreciate your quick help
On Tue, Jan 19, 2016 at 11:37 AM, Mandeep Baluja
wrote:
> Check this result of your first query. Second will done after completing
>> my ofc work :D Not have much time to involve today
>>
>
> Regards,
> Mandeep baluja
>
> --
>
Hi Experts,
Please help me on it. need it asap please
On Tue, Jan 19, 2016 at 2:58 AM, Puttu * wrote:
> Hi Team,
>
> Please help on the two excel VBA assignments Macros. both are very simple
> one, but I am not well versed in VBA.
>
> --
> Putta
>
> --
> Are y
Hi Team,
Please help on the two excel VBA assignments Macros. both are very simple
one, but I am not well versed in VBA.
--
Putta
--
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.faceboo
nge("a:a"),
> Sheets(i).Range("a" & j).Value) >= 1 Then
> Sheets(i).Range("a" & j).Offset(0, k).Value = wk.Name
> k = k + 1
> End If
> End If
> Next
> Next
> Next
>
Thanks Murali, this works out well, but if we have dynamic sheets, then
need to add vlookup formula every time.
Any how thanks for spending time and providing solution, really appreciate
that :)
On Tue, Dec 24, 2013 at 3:56 PM, Murali Nagarajan wrote:
> Dear Puttu,
>
> As desi
please help
On Tue, Dec 24, 2013 at 11:58 AM, Puttu * wrote:
> Experts please help on my query
>
>
> On Tue, Dec 24, 2013 at 8:35 AM, Puttu * wrote:
>
>> Hi Experts,
>>
>> Need your help. I have workbook which will have n number of sheets. What
>> I
Experts please help on my query
On Tue, Dec 24, 2013 at 8:35 AM, Puttu * wrote:
> Hi Experts,
>
> Need your help. I have workbook which will have n number of sheets. What I
> need is in each sheet column A we have listed some products, it need to
> search cell value (Product)
Hi Experts,
Need your help. I have workbook which will have n number of sheets. What I
need is in each sheet column A we have listed some products, it need to
search cell value (Product) in each sheets and if the value found just need
to enter the sheet name in next column, if the cell value (Prod
omparing each value using if ... = ... then
> looping in a row
> looping in a column
> Assign value to a cell, ex: Range("A1").value =
>
> You may ask it here one by one for your reference, i'am sure another
> members will help you and you got your learning s
please please advise, it's very important for me...
On Sat, Jul 27, 2013 at 4:55 PM, Puttu * wrote:
> Hi Experts,
>
> Need a help on copying the data from one workbook (Reference) to another
> workbook (master). I know asking too much, appreciate could you please help
&g
Experts really need your help on this macro.. please please
On Sat, Jul 27, 2013 at 4:55 PM, Puttu * wrote:
> Hi Experts,
>
> Need a help on copying the data from one workbook (Reference) to another
> workbook (master). I know asking too much, appreciate could you please help
please help me on the macro..
On Sun, Jul 28, 2013 at 10:14 AM, Puttu * wrote:
> Any updated on the macro team..
>
>
> On Sat, Jul 27, 2013 at 7:14 PM, Puttu * wrote:
>
>> Experts your assistance is much appreciated.
>>
>>
>>
Any updated on the macro team..
On Sat, Jul 27, 2013 at 7:14 PM, Puttu * wrote:
> Experts your assistance is much appreciated.
>
>
> On Sat, Jul 27, 2013 at 4:55 PM, Puttu * wrote:
>
>> Hi Experts,
>>
>> Need a help on copying the data
Experts your assistance is much appreciated.
On Sat, Jul 27, 2013 at 4:55 PM, Puttu * wrote:
> Hi Experts,
>
> Need a help on copying the data from one workbook (Reference) to another
> workbook (master). I know asking too much, appreciate could you please help
> me on this
Hi Experts,
Need a help on copying the data from one workbook (Reference) to another
workbook (master). I know asking too much, appreciate could you please help
me on this coding.
The workbook name different each time, i need dynamic name selection option
to select both the work sheets and data r
really very useful. Thanks
On Sat, Jul 13, 2013 at 1:07 PM, wrote:
> **
> Great collection. Thanks Ashish
> Sent from my BlackBerry® smartphone from Airtel Ghana
> --
> *From: * ashish koul
> *Sender: * excel-macros@googlegroups.com
> *Date: *Fri, 12 Jul 2013 21
012 at 10:57 PM, ashish koul wrote:
> try the attachment
>
> paste the full path of files in column A and run the macro
>
> Regards
> Ashish
>
>
>
>
> On Tue, Dec 11, 2012 at 12:56 PM, Puttu * wrote:
>
>> please help on this request..
>>
&g
please help on this request..
On Mon, Dec 10, 2012 at 6:46 PM, Puttu * wrote:
> Any update experts?
>
>
> On Mon, Dec 10, 2012 at 2:02 PM, Puttu * wrote:
>
>> Thanks for your response David,
>>
>> Sorry If I wasn't clear. Below is the answer for your
, 2012 at 12:10 AM, yogananda muthaiah <
yogananda.mutha...@gmail.com> wrote:
> Hi,
>
> Please try this if this can work out for u
>
>
>
> On Sat, Dec 8, 2012 at 10:21 PM, Puttu * wrote:
>
>> Experts please help me
>>
>> Need multiple data to past
Any update experts?
On Mon, Dec 10, 2012 at 2:02 PM, Puttu * wrote:
> Thanks for your response David,
>
> Sorry If I wasn't clear. Below is the answer for your questions. Attached
> is the reports and master excel how i am expecting.
> Let me know if you need any other detai
any help
Moderator could you please help on this
On Mon, Dec 10, 2012 at 11:24 AM, Puttu * wrote:
> can any one please...
>
> Need a macro to 5 workbook data to paste in single workbook, on one by one
> in the same sheet
>
>
> On Mon, Dec 10, 2012 at 12:
can any one please...
Need a macro to 5 workbook data to paste in single workbook, on one by one
in the same sheet
On Mon, Dec 10, 2012 at 12:05 AM, Puttu * wrote:
> SOME ONE HELP ME PLS
>
>
> On Sun, Dec 9, 2012 at 4:42 PM, Puttu * wrote:
>
>> Yogananda t
SOME ONE HELP ME PLS
On Sun, Dec 9, 2012 at 4:42 PM, Puttu * wrote:
> Yogananda thanks for your prompt response.
>
> My requiements is below
>
> 1. I have more than 5-10 work book in the folder
> 2. Macro should open one workbook and copy the data and past it new
> work
Experts please help me
Need multiple data to pasted in one single workbook
On Sat, Dec 8, 2012 at 7:38 PM, Puttu * wrote:
> Hi Experts
>
> I need a macro where i can use multiple workbooks to in single new workbook
>
> 1. I have multiple workbook in perticular folder, all tha
How to use this? getting error message.
On Tue, Oct 30, 2012 at 8:48 PM, Rajan_Verma wrote:
> *Execute it at 8 o clock*
>
> * *
>
> *Sub ShowPopUp()*
>
> * *
>
> *Msgbox “Send Massange”*
>
> *Application.OnTime Now+Timevalue(“01:00:00”),”ShowPopUp”*
>
> * *
>
> *End Sub*
>
> * *
>
> *Sub StopPop
= "CUSTM" Then
>
> perfix = Format("01650" & numbner, "")
>
>
> End If
>
>
> If Outlet = "FOOD" And Level = "MKT" Then
>
> perfix = Format("003000" & numbner, "")
>
>
>
then it should reflect
as 00201000
If len is 1 and outlet is FOOD and Level is REGION then it should reflect
as 0021
number Outlet Level OUTPUT 100 FOOD REGION 00200100 10 FOOD REGION
00200010 1000 FOOD REGION 00201000 1 FOOD REGION 0021
On Mon, Jul 23, 2012 at 2:08 PM, Puttu * wrote
0" & numbner
>
> End If
>
>
> If Outlet = "CLUB" And Level = "CUSTM" Then
>
> perfix = "01650" & numbner
>
>
> End If
>
>
> If Outlet = "FOOD" And Level = "MKT" Then
>
> perfix = "003000&
Thanks Amresh, I need to run this multiple sheets, can i have this in
macro. Which is going to help me a lot.
Appreciate your help
On Mon, Jul 23, 2012 at 1:10 PM, Amresh Maurya wrote:
> Hi,
> Kindly find the attached solutions.
>
> Regards
> Amresh
>
>
> On Mon, Jul 23,
Experts please help me on this code.
On Sat, Jul 21, 2012 at 7:15 PM, Puttu * wrote:
> Hi Experts,
>
> Please help on below macro need a macro to prefix on the below numbers. I
> just took one one example for refeence, but i have huge no. like this. Your
> help is m
Any update on the below help?
On Sat, Jul 21, 2012 at 7:15 PM, Puttu * wrote:
> Hi Experts,
>
> Please help on below macro need a macro to prefix on the below numbers. I
> just took one one example for refeence, but i have huge no. like this. Your
> help is much appreciated
&
Please help me on this experts
On Sat, Jul 21, 2012 at 7:15 PM, Puttu * wrote:
> Hi Experts,
>
> Please help on below macro need a macro to prefix on the below numbers. I
> just took one one example for refeence, but i have huge no. like this. Your
> help is much appreciated
&g
uille...@gmail.com
>
> *From:* Puttu *
> *Sent:* Saturday, July 21, 2012 8:45 AM
> *To:* MS EXCEL AND VBA MACROS
> *Subject:* $$Excel-Macros$$ Required Prefix Macro for the numbers
>
> Hi Experts,
>
> Please help on below macro need a macro to prefix on the below number
Hi Experts,
Please help on below macro need a macro to prefix on the below numbers. I
just took one one example for refeence, but i have huge no. like this. Your
help is much appreciated
*Number* *Outlet* *Level* *Code should some thing like this* *This is
how I am looking for output* 100 FO
Hey Vish,
Could you please send code for me the details in attahed excel sheet
I am looking automated mail to be sent by excel to outlook by using the
excel defined time and date
1st - Subject --> Column A is Subject " What user defined
2nd - Date & Time -> Column B is Date and time " What is us
most of the timings set only 8 hours window. It will create any unnecessary
problem
It would be great some one come with macro work on this.
On Thu, Jun 7, 2012 at 3:07 AM, netuser1110 wrote:
> Leaving Outlook + high speed Internet connection open 24/24, you put
> yourself at risk sending Buy V
Experts,
Can you have look on my requirements and provide the solution.
On Mon, Jun 4, 2012 at 12:19 AM, Puttu * wrote:
> Hi Excel Experts,
>
> Need a help on the macro for automated email reminders. below is the
> requirements. Attached is sheet for your reference
>
>
>
Can some one looking into details and provide me help.
On Mon, Jun 4, 2012 at 12:19 AM, Puttu * wrote:
> Hi Excel Experts,
>
> Need a help on the macro for automated email reminders. below is the
> requirements. Attached is sheet for your reference
>
>
> Need a macro ba
; End With
>
>
>
> Set OutMail = OutApp.CreateItem(0)
>
>
>
> On Error Resume Next
>
> With OutMail
>
> .To = cell.Value
>
> .Subject = " Month Target vs Achievement"
>
&
ma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Puttu *
> *Sent:* 04 June 2012 12:19
> *To:* MS EXCEL AND VBA MACROS
> *Subject:* $$Excel-Macros$$ Need a Email Macro based on the Cell time
&
Experts,
Could you please please help on the below request.
On Mon, Jun 4, 2012 at 2:00 PM, Puttu * wrote:
> below is the required details for your reference once again.
>
> Sr. No. Task (Subject Name) First Reminder Date & Time Second
> Reminder Date & Time Final
below is the required details for your reference once again.
Sr. No. Task (Subject Name) First Reminder Date & Time Second Reminder
Date & Time Final Reminder Date & Time Status Email Group 1 Status Mail 6/4/12
17:00 6/5/12 20:00 6/6/12 22:00 Inprogress puttu...@gmai
Hello Experts,
Any update on the below macro? Your help is much appreciated. Thanks
On Mon, Jun 4, 2012 at 12:19 AM, Puttu * wrote:
> Hi Excel Experts,
>
> Need a help on the macro for automated email reminders. below is the
> requirements. Attached is sheet for your reference
&
Hi Excel Experts,
Need a help on the macro for automated email reminders. below is the
requirements. Attached is sheet for your reference
Need a macro based on the given date and time in 1st, 2nd & Final reminder
columns to all the email ID Subject mail should be content of cell text in
the co
Hi Experts,
I want to learn excel, VBA in bangalore, I have basic knowledge in
both. Please advise any complete training institues where I can learn
and became master on this courses.
Also let me know how do I get MIS certified?? Do we have any online
video training for Excel and VBA & MIS which
Can you please please help any one
On Fri, Apr 1, 2011 at 5:40 PM, Puttu * wrote:
> sorry again, please hep me in the formula
>
>
> On Fri, Apr 1, 2011 at 5:12 PM, Puttu * wrote:
>
>> awaiting for your replay please.
>>
>>
>> On Fri, Apr 1, 2011 at
sorry again, please hep me in the formula
On Fri, Apr 1, 2011 at 5:12 PM, Puttu * wrote:
> awaiting for your replay please.
>
>
> On Fri, Apr 1, 2011 at 4:49 PM, Puttu * wrote:
>
>> Experts please help me on this it's bit urgent sorry to bother.
>>
>>
&g
awaiting for your replay please.
On Fri, Apr 1, 2011 at 4:49 PM, Puttu * wrote:
> Experts please help me on this it's bit urgent sorry to bother.
>
>
> On Fri, Apr 1, 2011 at 4:10 PM, Puttu * wrote:
>
>> Hi Experts,
>>
>> I have list of items which have
Experts please help me on this it's bit urgent sorry to bother.
On Fri, Apr 1, 2011 at 4:10 PM, Puttu * wrote:
> Hi Experts,
>
> I have list of items which have not full codes. I need them to convert full
> code. Could you please help me.
>
> Item code column has eithe
Hi Experts,
I have list of items which have not full codes. I need them to convert full
code. Could you please help me.
Item code column has either 3, 2, 4 & 5 digits no. but by default they
should be either 6 or 7 or 8 digits code. What best formul I need to use to
get that output. Item Full Cod
Thanks a lot it worked out me. Cold you please help on my second question
in Attached is the sheet
On Fri, Feb 25, 2011 at 5:42 PM, Vikas Chouhan wrote:
> Hi Puttu,
>
>
> if you are using Excel 2007 then
>
> use formal : - =IFERROR((IF(VLOOKUP(C12,Ukey,1,0),"
> YES&qu
Attached is the question with attachment. Please help me out
On Fri, Feb 25, 2011 at 5:22 PM, Puttu * wrote:
> No Still not working
>
>
> 2678
>
> YES
>
> This is fine
>
> 2558
>
> #N/A
>
> This one I want as blank (if the data doesn't match the
ung wrote:
> Hi Puttu,
>
> it is working well see the attachment, r u sure you are putting right
> criteria in your data, pls. send the sample sheet for understanding,
>
> Thanks & Regd
>
> ROHAN
>
>
> On Thu, Feb 24, 2011 at 8:16 PM, Puttu * wrote:
>
>
Team, Please help me on this
On Thu, Feb 24, 2011 at 6:13 PM, Puttu * wrote:
> Hi Experts,
>
> I have two questions
>
> 1. I am using Vllokup formula =IF(VLOOKUP(C12,Ukey,1,0),"YES", " ") in this
> if any error it shows as #N/A, insted of this i want it
Hi Experts,
I have two questions
1. I am using Vllokup formula =IF(VLOOKUP(C12,Ukey,1,0),"YES", " ") in this
if any error it shows as #N/A, insted of this i want it show as balnk, how
to do this?
2. In Vlookup formula if the result is found in different excel, i want that
sheet name to be visibl
Any body have any suggetion
On Wed, Feb 2, 2011 at 9:30 AM, Puttu * wrote:
> Hi Experts,
>
> Required your advise on VBA training, I am looking for VBA best training in
> Basavanagude or Gandhibazr Bangalore. Could any body have any good training
> institute please provide me
Your suggetion is much appriciateable
On Wed, Feb 2, 2011 at 9:30 AM, Puttu * wrote:
> Hi Experts,
>
> Required your advise on VBA training, I am looking for VBA best training in
> Basavanagude or Gandhibazr Bangalore. Could any body have any good training
> institute please
Hi Experts,
Required your advise on VBA training, I am looking for VBA best training in
Basavanagude or Gandhibazr Bangalore. Could any body have any good training
institute please provide me the address or phone no. to contact.
--
Putta
--
-
Hi Experts,
I need help , I need a macro or formula where as in excel where ever I
found YES it should insert additional row bleow to that YES.
Can you please help me.
Thanks
Puttu
--
--
Some important links for
aharashtra
Rajesh Jesrani Spices,
grounded spices, processed foods, canned vegetables, dals, rice,
pickles, chutneys, jam, papads, agarbattis
Could you please advise how to do that.
Th
Hello Team,
I need a formula or VB macro where as I have two different sheets with
Same data, when it match the result should show in other sheet next
column as YES
If one value match then the answere should be YES in different xl.
example
XX #XX Name
100 NORTH FAFA
500 NORTHFA
700
Other Goods Tab sheet with Goods Code.
It would be great help if any help out on this.
Thanks
Puttu
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.c
Hi Team,
Can you send me any step by step procedure Document to learn Basic VBA
2006.
Is there any document which i can go through? or else any video
tutorial website to learn VBA?
It would be great help if provide those details.
Thanks
Puttu
Hi Team,
Can any hlep me how recover my password, I lossed it. If i want to
attach let me know how can i attach to this blog?
Thanks
Putta
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
79 matches
Mail list logo