Experts please help me on this code.
On Sat, Jul 21, 2012 at 7:15 PM, Puttu * puttu...@gmail.com 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
Hi,
Kindly find the attached solutions.
Regards
Amresh
On Mon, Jul 23, 2012 at 12:40 PM, Puttu * puttu...@gmail.com wrote:
Experts please help me on this code.
On Sat, Jul 21, 2012 at 7:15 PM, Puttu * puttu...@gmail.com wrote:
Hi Experts,
Please help on below macro need a macro to prefix
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 amreshkushw...@gmail.comwrote:
Hi,
Kindly find the attached solutions.
Regards
Amresh
On Mon, Jul 23, 2012 at
Hi ,
I have attached a function for you kindly add it in your add-ins and use.
Function perfix(Outlet As String, Level As String, numbner As Integer)
If Outlet = FOOD And Level = REGION Then
perfix = 00200 numbner
End If
If Outlet = DRUG And Level = REGION Then
perfix = 02200 numbner
Dear Amresh kushwaha
U can use vlooup is these
=VLOOKUP(B8,H3:J8,3,0)A8
On Mon, Jul 23, 2012 at 1:52 PM, Amresh Maurya wrote:
Hi ,
I have attached a function for you kindly add it in your add-ins and use.
Function perfix(Outlet As String, Level As String, numbner As Integer)
If Outlet =
Thanks Amresh,
I think this serve my purpose, but need one more thing, since are vary one
cell have 2 digits no. and one have 3 digit numbers and one have 4 digit
numbers in the cell, finally it should be ending with 8 digit no. Is there
any way to put in code?
On Mon, Jul 23, 2012 at 1:52 PM,
This is how the output I am looking for each creteria. with the VBA code
If len is 3 and outlet is FOOD and Level is REGION then it should reflect
as 00200100
if len is 2 and outlet is FOOD and Level is REGION then it should reflect
as 00200010
If len is 4 and outlet is FOOD and Level is REGION
Thanks Amresh, This is what i was looking. Appreciate your timely help.
Thanks again a lot :)
On Mon, Jul 23, 2012 at 3:06 PM, Amresh Maurya amreshkushw...@gmail.comwrote:
Hi ,
find the attached file.
use this code.
Function perfix(Outlet As String, Level As String, numbner As Integer)
Hi Don,
kindly explain how did you do that.
Regards
CK
On Fri, Jul 20, 2012 at 8:56 AM, dguillett1 dguille...@gmail.com wrote:
See attached file that automatically makes a drop down in range d9 when
you activate the sheet and when you select the date from the drop down will
populate the
Dear Mr Don,
I need your help for transaction of data from one file to another.
We have attached one excel file named Monthly Transaction Report June 2012
in our last mail with two sub files in that (1) New joining date wise,
which is our data file of employees and (2) Transaction report.
Hi all
How to update stock prices from website in excel.In my excel 50 stock I
want to update prices that stock when I open excel open nseindia website
then update prices.I think in excel it is from Data-Import External
Data-New web query.
Daily basis I open include 50 stock excel from
hi Pascal
Thanku so muchit really helped meappreciate your help. even it
increased my knowledge in VB...
plz explain below part of code... thanks again
If rCol 1 Then
v = Array(r)
.Rows(i + 1 : i + rCol - 1).Insert
Dear Amar,
See attached sheet, Hope it help to you.
On Thu, Jul 19, 2012 at 4:24 PM, amar takale amartak...@gmail.com wrote:
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help,
Hello Amar,
Check this
http://www.vertex42.com/News/excel-web-query.html
On Mon, Jul 23, 2012 at 6:17 PM, amar takale amartak...@gmail.com wrote:
Hi all
How to update stock prices from website in excel.In my excel 50 stock I
want to update prices that stock when I open excel open nseindia
I would have used SELECTCASE
Option Compare Text
Option Explicit
Sub selectcaseloopSAS()
Dim c As Range
Columns(c).NumberFormat = 0
For Each c In Range(a2:a12)
Select Case c.Offset(, 1) c.Offset(, 2)
Case FOOD REGION: c.Offset(, 3) = 00200 c
Case FOOD MKT: c.Offset(, 3) =
Option Compare Text
Sub selectcaseloop()
Dim c As Range
Columns(f).NumberFormat = 0
For Each c In Range(a2:a12)
Select Case c.Offset(, 1) c.Offset(, 2)
Case FOOD REGION: c.Offset(, 5) = 00200 c
Case FOOD MKT: c.Offset(, 5) = 00300 c
Case drug region: c.Offset(, 5) = 02200 c
Case
Hi guys I have a report which I downloaded from crystal report to excel,,
choosing the dates and then compiling the report to excel. I´m trying to do
a Macro which has to go to 3 conditions and then sum to another column
segunda-feira terça-feira quarta-feira quinta-feira sexta-feira
check the attachment see if it helps
On Mon, Jul 23, 2012 at 9:29 PM, John A. Smith johnasmit...@gmail.comwrote:
Esteemed Excel Teachers - How would I go about creating a macro that would
open an Outlook draft and paste the highlighted range from my excel
spreadsheet into the body of the
My Vba coding style is much inspired from Kris who from what I know, posts
here and on excelfox.com. If you can read his code, you should learn many
tricks.
If rCol 1 Then
v = Array(r)
.Rows(i + 1 : i + rCol - 1).Insert
.Range(.Cells(i,
in tools - reference - choose Microsoft outlook..
On Mon, Jul 23, 2012 at 9:57 PM, John A. Smith johnasmit...@gmail.comwrote:
Ashish,
Thank you for the quick reply. I get an error when I copy and paste your
macro in my spreadsheet. I attached a screen print of the error. A user
defined
That was it. I will go over this with a fine tuned comb and learn all I
can. Thank you most graciously for your much appreciated help.
John
On Mon, Jul 23, 2012 at 12:52 PM, ashish koul koul.ash...@gmail.com wrote:
in tools - reference - choose Microsoft outlook..
On Mon, Jul 23, 2012 at
You need to send ME a FILE showing EXACTLY what you want
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: amar takale
Sent: Thursday, July 19, 2012 11:58 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Company Name in front of Show its
Thank you very much Don.
On Mon, Jul 23, 2012 at 5:26 PM, B.N.Chethan Kumar
chetankumar1...@gmail.com wrote:
Hi Don,
kindly explain how did you do that.
Regards
CK
On Fri, Jul 20, 2012 at 8:56 AM, dguillett1 dguille...@gmail.com wrote:
See attached file that automatically makes a
Dear expert
I was able to save excel data to DBF III file through save as option in
97-2003 version, But in 2007 version how could i save excel data to DBF III
format as i am unable find save as to dbf option in 2007 version of Excel.
Please advice me.
Thanks in advance
Govind Mori
--
--
Hi Team,
I have a morethan 10 workbooks in a folder , I need a macro for
consoldate all workbooks into single workbook.
1) some of the sheets have morethan 70,000 recoreds (rows) filled
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor
25 matches
Mail list logo