Hi Vijay,
Herewith i have attached the completed excel.
By,
Suresh
Cell : 9894585740
On Monday, July 10, 2017 at 5:29:17 PM UTC+5:30, Vijayendra wrote:
>
> Hi Experts,
>
>
> Request you to help to resolve this below query.
>
> Need to change the cell based on selection of other cell. Attached i
this needs to be changed:
Range(ActiveCell, ActiveCell.End(xlUp).Offset(1, 0)).Value = SN
and the macro needs to be changed to accomodate the change above,
Sub CopyAll()
Application.ScreenUpdating = False
Dim cnt As Long
Dim r As Range
For i = 1 To Sheets.Count - 1
Sheets(i).Select
SN = ActiveShe
results.
There is an option "Difference of" but it not showing proper results.
*I Can alternatively put minus signs in all the sales transactions but that
is not possible for a big database.*
Any easy alternative solution will be highly appreciable.
Thanks in advance.
B. Sharma
--
Hi Kiran,
Herewith i have attached as you asked.
Please check & let me, if you have any questions.
*Thanks & Regards,*
*Suresh Kumar.B*
*Mobile # 9894585740*
On Thursday, February 2, 2017 at 12:53:41 AM UTC+5:30, Kiran Kancherla
wrote:
>
> Hi All:
>
> I have different kind of requirement in wh
Hi *Sachin*,
As you said, I have made changes in the file through formulas
Please check & let me know, If any Changes.
*Thanks & Regards,*
*Suresh Kumar.B*
*Mobile #9894585740*
On Friday, February 17, 2017 at 10:53:19 AM UTC+5:30, सचिन शर्मा wrote:
>
> Thanks Suresh,
>
> It's working and show
Dear Sachin,
Herewith i have attached the completed file as you requested.
Please Check & let me know, If you have any questions.
Thanks,
Suresh Kumar.B
Mobile # 9894585740
On Monday, February 6, 2017 at 4:24:42 PM UTC+5:30, सचिन शर्मा wrote:
>
> Dear Experts,
>
> Please help to resolve below
Hi,
Herewith i have attached the Completed file.
Please check and ask, If any.
Thanks&Regards,
Suresh Kumar.B
Mobile # :9894585740
On Thursday, May 26, 2016 at 3:49:59 PM UTC+5:30, sonu wrote:
>
>
> Dear Expert,
>
> I want a macro to convert data from pivot form to normal form.
>
>
>
> --
>
In addition to the above,,,
You can check the path by the following formula
=Cell("filename")
On Wednesday, June 8, 2016 at 5:14:42 PM UTC+5:30, B Sharma wrote:
>
> Hiii Pravin,,
> From your screen shot I think that both the files are at different
> location...
>
Hiii Pravin,,
>From your screen shot I think that both the files are at different
location...
Please check that in the first first there is only one sheet, and in the
another file there are 2 sheets (one new with name "Master")
Please carefully check the path of the file which you open in the sh
Hello Excel Friends,
I am using the below formula which was working fine for me
=SUMPRODUCT(SUMIFS(range 1,criteria 1, range 2,Criteria 2,range 3,*Defined
Name Range 1 *))
but I needed one more name range to add in this formula , but it stopped
working and showing wrong results...
Can somebod
First I am very much a amateur and
I am attempting to create a multiple choice test in excel 2010. I have the
formula and macros down. My problem is there are 218 questions with 3 choices
per question and it seems that I can only use 52 shortcut key combinations. Is
this correct or is their anot
Hi,
Herewith i have attached the solved excel.
If you have any questions, Please let me know.
*Thanks & Regards,*
*Suresh Kumar.B*
*Mobile # 9894585740 *
On Tuesday, December 15, 2015 at 12:28:19 AM UTC+5:30,
mortgagep...@gmail.com wrote:
>
> Dear Experts:
>
> Do you know if it is possible t
d to clients. I need to accomplish using an iMac
running excel 2016.
Thank you, Vikas!
On Tuesday, August 18, 2015 at 5:02:03 PM UTC-5, Mike B wrote:
>
> I would appreciate if someone would look at this formula and tell me what
> I am doing incorrectly; I have a large spreadsheet called POS where I have
> different variables separated and I am tryi
ee my
formula below
'=IF(AND(ISERROR(VLOOKUP(A5388,POS!$A$2:$B$97,2,0)),"n/a",VLOOKUP(A5388,POS!$A$2:$B$97,2,0)),IF(ISERROR(VLOOKUP(A5388,POS!$H$5:$I$97,2,0)),"n/a",VLOOKUP(A5388,POS!$H$5:$I$97,2,0)),IF(ISERROR(VLOOKUP(A5388,POS!$O$5:$P$97,2,0)),"n/a",VLOOKUP(A538
I would appreciate any help with creating a macro to email individual PDF
documents to each client's email that is chosen from a list matched to the
client's PDF to send as an attachment.
Thank you,
MikeB
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO
you,
Mike B
=GETPIVOTDATA("Net Terminal Income",$A$3,"dba","17 North","Reporting_Period
",1,"z_Month","Jan 2015","IGB Number","513140","Manfacturer","IGT","VGT","VGT
01")
heets("Sheet1").Cells(i, 2).Clear
> Sheets("Sheet1").Cells(i, 2).Interior.Color = "255,0,0"
> End If
> i = i + 1
> Wend
> MsgBox ("Done Successfully")
> ThisWorkbook.Save
> ThisWorkbook.Worksheets("Sheet1").Activate
>
> End S
acters of the
short name in column "A" of sheet 1 to find the first five characters in
column "C" sheet 4 of the longer names and copy the longer names and paste
them in column "B" of sheet 1. Does anyone know if this can be done? I am
new to VBA and strugglin
Hi All
I am asking for advice! I have just been tasked with preparing some charts
of aggregated data. I am be asked to prepare four charts of customer
semi-monthly statements showing some revenue and trends of individual
items, then print a PDF file and email to each individual customer (a
I would like to copy this for each location and paste in front inventory
numbers in Column "A"(some begin with letters) and also in front of the
Establishment Totals: VC Count.
Then I would like to Remove the Word "Establishment" in from of the Totals:
VC Count.
Then I would like to delete the
I recommend to create a
> macro to copy and paste each table constantly.
>
> I attached an exemple.
>
>
>
> André Luiz D´Avila
>
> 2015-03-13 10:41 GMT-03:00 B Sharma >:
>
>> Dear All Excel Experts,
>> From a very long time, I am trying to create a piv
Dear All Excel Experts,
>From a very long time, I am trying to create a pivot table using two or
more tables, but not getting appropriate results.
Please help me , if anybody has ever done so.
For e.g. in one table there are purchase details and in another column
there are sale details..
I wan
Hi Mandeep,
I would appreciate you looking at the attached worksheet, I have written
and explanation in a comment on the worksheet explaining the issues I am
experiencing, I thought it would be easier for you to understand.
On Sunday, March 8, 2015 at 12:08:13 PM UTC-5, Mike B wrote:
> Th
Thank you, thank you so much for all your help and quick response!! I am
going to have to study my books to understand your code fully, it is so
precise and quick. Thank you again, Mandeep!
On Thursday, March 5, 2015 at 10:16:12 AM UTC-6, Mike B wrote:
>
>
>
> I try it works but
, 2015 at 10:16:12 AM UTC-6, Mike B wrote:
>
>
> I try it works but goes back to what I just did even though I moved my
> cursor down 11 rows. I would appreciate any help how to get it to advance
> to the next block that I am trying to copy and paste. I have about 7,000
>
n December 2014 that I want to find and copy to
column "B" in front of each CGT for that date, some dates have five CGT's
which is the maximum number of CGTs for a specific date. Please find below
the code I was trying to use, it works but doesn't copy for all CGTs and
d
I try it works but goes back to what I just did even though I moved my
cursor down 11 rows. I would appreciate any help how to get it to advance
to the next block that I am trying to copy and paste. I have about 7,000
rows of data to do.
Thank you
Mike B
Sub just_dates2()
'
' j
Hi Ahmad,
Here you go!!!
By,
Suresh Kumar.B
On Tuesday, February 24, 2015 at 12:45:22 AM UTC+5:30, Ahmad Mustfa wrote:
>
> Thanks Kumar.
> Can you please send me in the excel file. i am trying but unable to
> understand to how to do that.
>
> On Mon, Feb 23, 2015 at 6:59
Hi Ahmad,
Please follow my instructions to clear what do you want,
Steps:
1. Goto to Excel page, Press CTRL+F11
2. After that, in the left hand side shows the sheets menu, Double click
that after paste the following code.
*Private Sub Worksheet_SelectionChange(ByVal Target As Range)*
*Dim r As
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:* Mahesh B >
> *To:* excel-...@googlegroups.com
> *Sent:* Monday, Febru
Hello,
Myself is Mahesh, Can some one please check this and let me know since it
is an urgent issue.
Thank You In Advance.
Mahesh Baad
On Monday, 16 February 2015 16:09:25 UTC+5:30, Mahesh B wrote:
>
> Hello Team,
> I am new member to this group. PFA excel issue file. The p
:28 PM, Vaibhav Joshi >>>>>> > wrote:
>>>>>>>
>>>>>>>> You want to learn VBA then start modifying last code which i sent
>>>>>>>> to you to accommodate it..
>>>>>>>>
>&
Dear Excel Gurus,
I am trying to update my excel sheet which contains the TIN number of some
of the registered tax payers with their contact details and address. I can
do it manually by putting the TIN number in the below mentioned website and
then copy paste the details in the excel file.
But
.box.com/s/szaxukie20xnutka8f3e*<https://app.box.com/s/szaxukie20xnutka8f3e>
*
https://www.facebook.com/photo.php?fbid=525682004167816&set=a.209740072428679.47011.15180389897&type=1&theater
*
On Wed, Oct 2, 2013 at 6:13 PM, B V Dileep wrote:
> Hi, could please send me any tutorial
excel and connect it with access db using ado
>
> Regards
> Ashish
> Sent on my BlackBerry® from Vodafone
> --
> *From: * B V Dileep
> *Sender: * excel-macros@googlegroups.com
> *Date: *Wed, 2 Oct 2013 06:44:22 -0500
> *To: *
> *ReplyTo:
Hi, Just now I heard that creating forms and bit of VB code will work is it
true?
On Oct 2, 2013 4:21 PM, "xlstime" wrote:
> no its not possible with only excel... need to create another database
> like ..ms access or sql
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Wed, Oct 2, 2
2013 03:36:42 UTC+5:30, Tom B. wrote:
>>
>> Hi
>>
>>
>>
>> I have a spreadsheet that records user inputs and then stores the inputs
>> along with Date/Time and user ID.
>>
>> Since this will be accessed on a shared computer, that User
Check it and let me know is it ok.
On Fri, Jul 26, 2013 at 4:11 PM, Prafull Jadhav wrote:
> Dear Anil,
>
> thanks for the same.
>
> Actually I require one chart which contain all information .
>
> Regards
> Prafull Jadhav
>
>
> On Fri, Jul 26, 2013 at 3:52 P
Hi Prafull,
Find attached the attractive chart as you requested.
Thanks,
Anil
On Fri, Jul 26, 2013 at 3:26 PM, Prafull Jadhav wrote:
> Dear Expert ,
>
> I have made pivot ..I want to make it one Graph.
>
> I am not able to make it in one Graph...
>
> Can anyone can provide the same with attrac
Hi Waseem,
Just use this formula u will get the results.
=+GETPIVOTDATA(" Category ",$G$1," Category ","> 7 Days")
Thanks,
Anil
On Tue, Jul 23, 2013 at 2:26 PM, Waseem Saifi wrote:
> Dear Experts,
>
> Please look into attached file. I want to find out percentage of each
> category. Using Pivo
its simple dude paste as special and select transpose thats it.
Thanks,
Anil
On Wed, Apr 3, 2013 at 5:52 PM, prafull jadhav wrote:
> Dear All,
>
> I attached the sheet in which I require data vertically with company name.
>
> example data is attached .
> Regards,
> Prafull Jadhav.
>
> --
> Ar
Dear Santosh,
Please find the file, Hope this will help you..
On Sunday, March 24, 2013 2:09:41 PM UTC+5:30, santosh wrote:
>
> Hello Group,
>
> I need a way to highlight the amts that I can offset with each other based
> on the below conditions:
>
> 1) Customer should be same
> 2) Profit Center
Hi Experts,
find attached the excel sheet
I need ur help to pull up the report by just one click on button with the
help of Macros and i have total eight reports for your information i dont
want hyperlink option.
Thanks,
Anil
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
ya It will be helpful who needs job.
Thanks,
Anil
On Tue, Mar 5, 2013 at 1:24 PM, Surbhi Agarwal wrote:
> Thanks Pankaj for this post. I think no one face any type of problem if
> some one post job on a wall of this group. Because it would be help of some
> one if they need of this post
>
> Reg
listen for this one to attach the PDF Files u just need to hyperlink the
file from desktop or file thats it u got the solution when u click it opens
the file.
Thanks,
Anil
On Mon, Feb 25, 2013 at 7:28 PM, Anil B wrote:
> Hi dude,
>
>
>
>
> On Mon, Feb 25, 2013 at 7:23 PM,
Hi dude,
On Mon, Feb 25, 2013 at 7:23 PM, amar takale wrote:
> Dear All Experts,
>
> Discuss to all about PDF attachment in Excel Cell
>
> Regards
> Amar
>
>
>
> --
> 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
Please try the simplest one...
=SUMIF(C2:C15,"<="&6500)+COUNTIFS(C2:C15,">6500")*6500
On Saturday, February 23, 2013 4:06:15 PM UTC+5:30, Ranjeet Negi wrote:
>
> Dear Sir,
>
> I have a data in Range (C2:C50). There are values. I want to sum all
> value upto or equal to 6500, wherein values gre
Dear Friends & Excel Experts,
I have a Excel 2007 file of around 5 MB (which I saved in binary format.
Last week it suddenly got corrupted and I am now unable to open it ,
While opening it says "The work book cannot be opened or repaired by MS
Excel because it is corrupt"
Please help me in this
Hiii Rajan,
Please find the link..
http://www.developer.nokia.com/Resources/Tools_and_downloads/Other/PC_Connectivity_API/
Hope that you are searching for the same.
On Sunday, July 8, 2012 10:06:36 PM UTC+5:30, Rajan_Verma wrote:
>
> *Hi Group,*
>
> * *
>
> *I am searching for PC Suit API, if
if I have two tables in a sheet then it will delete the row from
each of the tables.
Thanks..
On Saturday, July 7, 2012 11:45:32 AM UTC+5:30, B Sharma wrote:
>
> Wow,
> Great,
> Marvellous,
>
>
> I gets excited when I see the beauty of Macros...
> A combination of fe
vbCritical, "Stop!"
> Exit Sub
> End If
> Application.ScreenUpdating = False
> Do Until Selection.Value = ""
> ActiveCell.Offset(1, 0).Range("A1:A" & InsQuan).Select
> Selection.Insert Shift:=xlDown
> ActiveCell.Offset(InsQuan, 0).Select
Dear Friend Noorain,
Thanks for your quick reply...
I tried this but failed, I was unable to insert rows in the table.
I have attached a file for your reference too.
Please see and help.
BS
On Friday, July 6, 2012 5:15:20 PM UTC+5:30, B Sharma wrote:
>
> Dear Excel Experts,
>
&
Dear Excel Experts,
I have a protected data sheet, where I want to insert row where the cursor
is selected.
I need a VBA code who will do the following:
1. Unprotect the sheet (with password)
2. Insert a row in the table where the cursor is pointed.
3. Protect the sheet (with password)
I need
বন্ধুরা আজকে আপনাদের সবাইকে একটি নতুন সামাজিক আয় করার সাইটের সাথে পরিচয়
করিয়ে দিব। জেনে খুশি হবেন যে সাইটটি বাংলাদেশীদের এবং দারুন একটি সাইট।
সাইটটি Facebook এবং Odesk এর সমন্বয়ে তৈরি করা। মানে হল আপনার এই সাইটটিতে
Facebook এর মত করে নতুন বন্ধুর তৈরি করতে পারবেন আবার Odesk এর মত আয়ও করতে
পারবেন
Dear Friends and excel experts,,
I have a sheet in which there are columns like "Qty""Rate" of purchase
of items,
In Another sheet I need a formula for auto calculation of consumption value
of goods for the given quantity in FIFO method (First In First Out)
I have tried all my known tricks,
please unsubscribe the posts
From: Maries
To: excel-macros@googlegroups.com
Sent: Saturday, February 25, 2012 10:04 PM
Subject: Re: $$Excel-Macros$$ Extract last digit number
My Try:
=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)
On Sat, Feb 25, 2012
Hello Friends.
I have two sheets For E.g.
1. Opening Balances and purchases of goods
2. Consumption of goods
Both the sheets will contain many colours like.
purchase date,consumption date, inv. no. party name., item, qty. ,
values, etc.
Now I need to create a Pivot table, in which
Hey Rajan,
Congratulations to you on this achievement.
Hope this year will be fantastic for you and "you will add a member in
your family soon."
Thanks & Regards,
BS
On Jan 3, 11:20 pm, Ayush Jain wrote:
> Hello Everyone,
>
> Wish you a very happy new year !!
>
> Rajan Verma has been selec
Happy Birthday Noorain
and thanks to Rajan for this info..
God bless both of you and whatever is your dream you achieve that.
Thanks & Regards,
BS
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urge
Dear friends
thanks for replyinng
But I havrent got my solution
On Dec 3, 11:19 pm, NOORAIN ANSARI wrote:
> Dear B. Sharma,
>
> Read this article or use VBA Macro mentioned
> thereby:-http://www.excelitems.com/2010/11/shrink-reduce-excel-file-size.html
>
> Thanks & reg
Dear Excel Experts...
I have created two separate work book.
1st one is the database and 2nd one is the report / summary file
now my query is that while checking the reports I dont want to open
the database file ,, currently I have to open both file for working.
Is there any easy way.
2ndly pl
Dear Excel Experts.
I have created a drop down list using data validation and the source
of the list is a dynamic range created at another sheet.
I have checked "Show error alert after invalid data entered"
Its working fine and showing the source list in the drop down list but
it also accepts an
Dear Don & other experts
Coloumn A has raw data and column B have sorted data
Before After
52 193
86 195
92C 52
94B 86
94B 87
195 92C
193 94B
ABC 94C
XYZ 94J
94K
94C
like this...
I want a output in column B where it will ignore the duplicate items
and sorted figures.
I think its quiet difficult but please try this ...
Thanks & Regards,
B. Sharma
--
--
Some importan
> Hi,
>
> Use the formula :-
> =OFFSET($A$1,MATCH($B$1,$A$1:$A$6,1)-1,0)
>
> Sample worksheet is also attached for your ready reference. Let me
> know if this suits your requirements.
>
> Regards,
> DILIPandey
>
> On 10/12/11, B Sharma wrote:
>
>
>
>
Hi Sanjib ... can you please send me your email id so that i can
send you a sample file..
On Oct 12, 5:02 pm, Sanjib Chatterjee
wrote:
> B. sharma.
>
> goto vba = module1=>paste the code
>
> in excel write a date = inset the function from userdefined function
>
> S
Dear Sanjib.
there is no option there to attach the file
please help
On Oct 12, 12:16 pm, Sanjib Chatterjee
wrote:
> dear
> B Sharma
> please send me the sheets
>
> sanjib
>
>
>
>
>
>
>
> On Wed, Oct 12, 2011 at 12:37 PM, B Sharma wrote:
> >
Dear Excel Experts
I want to select a date which is either equals to or lesser than the
select date.
For Example
in Column 1 I have different dates
01-Apr-2010
01-Jul-2010
15-Aug-2010
01-Oct-2010
15-Nov-2010
08-Aug-2010
(sorted and un sorted both)
In Cell B2 I have entered a date, say. 1
file to
> better understand your Query,
>
> Rajan.
>
>
>
>
>
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>
> On Behalf Of B Sharma
> Sent: Tuesday, August 16, 2011 12:53 PM
> To:
...
--
Thanks & Regards,
B. Sharma
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/gr
use arrays
with refernces..),
DSUM(database, field, A1:D2, G1:G2) (too many arguments..).. etc.
What can I do?
If anyone has an idea please let me know !!
B. Sharma
--
--
Some important links for excel users:
1. Fo
Congrats to my lovely friend.. Hey Rajan... carry on your
social work dude.
On Aug 5, 11:08 pm, Manish wrote:
> CongratulationsRajan... :)
>
> -
> Manish
>
> On Aug 5, 9:37 pm, neil johnson wrote:
>
>
>
>
>
>
>
> > CongratulationRajan.
>
> > On Fri, Aug 5, 2011 at 8:57 AM, Haseeb
Use the following formula.
=SUMIF($A$3:$A$322,$F$3:$F$16,$C$3:$C$322)
On Fri, Aug 12, 2011 at 4:49 PM, naresh v wrote:
> I Have mentioned my problem clearlyplease find attached sheet
>
>
> Regards,
> Naresh V
>
> --
>
> ---
Pdt Jan Feb March April May June July
A 0.52 0.60 0.60 0.71 0.71 0.66 0.00
B 0.72 0.72 0.71 0.86 0.96 0.81 0.77
C 3.84 4.35 4.39 3.88 4.23 4.06 3.69
D 1.16 1.49 1.49 1.49 1.67 1.92 0.00
E 1.13 1.32 1.32 1.57 1.57 1.44 0.00
F 1.14 1.29 1.29 1.29 3.12 3.18 0.00
I can to apply conditional formatting
e of duplicacy..
>
> See attached Sheet...
>
>
> =IF(COUNTIF($E$4:E4,E4)>1,VLOOKUP(E4,CHOOSE({1,2},$B$4:$B$20,$A$4:$A$20),2,1),VLOOKUP(E4,CHOOSE({1,2},$B$4:$B$20,$A$4:$A$20),2,0))
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.blogspot.com/
All,
Have a excel workbook with around 15 tabs ..each of tab has multiple
pivots referring to different sets of data. All the pivots refer to 4
data sets in all .What is the best way of refreshing these multiple
Pivots in different tabs at one go?
Regards,
Ruchi
--
-
Ashish Koul
Thank you soo much for the help...
On Wed, Feb 16, 2011 at 8:31 PM, ashish koul wrote:
> check the attachment
>
> On Wed, Feb 16, 2011 at 6:19 PM, Jagadeesh B S wrote:
>
>> Hello all
>>
>>
>>
>> I have date like
>&
Ashish Koul
Its not working...:(
Regards
Jagadeesh B S
On Fri, Feb 4, 2011 at 12:15 PM, ashish koul wrote:
> HI
>
> try this see if it helps
>
> paste unique names and email ids on sheet 3
>
>
>
> On Thu, Feb 3, 2011 at 2:50 PM, Jagadeesh B S wrote:
>
>>
as attachment also
>
> r u using outlook or notes
>
> On Thu, Feb 3, 2011 at 12:16 PM, Jagadeesh B S wrote:
>
>> Hello friends.
>>
>> Can any one help me on this?
>>
>> Thanks in advance
>> Jagadeesh B S
>>
>> On Wed, Feb
Hello friends.
Can any one help me on this?
Thanks in advance
Jagadeesh B S
On Wed, Feb 2, 2011 at 5:30 PM, Jagadeesh B S wrote:
> Hello friends I am looking for solution for our intercompany company
> reconciliation report.
>
>
>
> I have data as per the sheet *dat
the regard.
Looking forward for some help.
Thanks
Jagadeesh B S
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
Hello All,
Please can somebody advise me macros for paste special-transpose wherein i
can just copy the data in horizontal format and paste them in vertical with
a shortcut key.
My data looks something like below in different sheets of same workbook
2009 2008 2007
1.2 0.84 0
Hey Susan,,
If you have that book then please send it to my email address or
attach here...
my email address issharma(dot)ctc(at the rate)gmail(dot)com
Thanks & Regards,
B. Sharma
On Dec 30 2010, 9:43 pm, "Susan" wrote:
> I useExcel2007 Visual Basic for Applications, St
Congratulations Dlip.:)
Thanks
Jagadeesh B S
On Mon, Jan 3, 2011 at 3:31 PM, Ayush wrote:
> Dear Group,
>
> I am very very very very happy to share a good news with you. One of our
> dearest group member "Dilip Kumar Pandey" is awarded Microsoft MVP award on
H Steve,
No attachment found,,..
Please send your attachment and then we will try to answer.
Thanks & Regards,
BS (sharma@gmail.com)
--
--
Some important links for excel users:
1. Follow us on TWITTER for tip
Dear Friends,
Firstly I want to thank you all for making and using this wonderful
educational site. Its really superb.
I am somewhat good in excel inbuilt formulas & functions and able to
complete most of my work through that.
But I need your help as I want to learn VBA programming & Macros and
w
Ashish Koul
Could you please help me in understanding the formula and how did it...Pls
help to learn writing complex formulas.
Thanks in advance
Jagadeesh B S
On Tue, Nov 30, 2010 at 1:07 PM, ashish koul wrote:
> Check the attachment see if it helps
>
>
> On Tue, Nov 30, 2010
helping others.
*
On Tue, Nov 30, 2010 at 12:18 PM, amrahs k wrote:
> Hope this helps. Have a look at the attached workbook.
>
> On Tue, Nov 30, 2010 at 11:35 AM, Jagadeesh B S wrote:
>
>>
>> Hello Friends
>>
>> I need a formula or macro( preferabley for
Hello Friends
I need a formula or macro( preferabley formule) need to prepare this report
.
I need a formula which should get the details for the account # mentioned in
the column A with the reference to the currency,form the sheet DATA, if the
currency is USD It should pull the value in the colu
Hello all,
Could someone please help me for my requirement
Thanks in advance
Jagadeesh B S
On Fri, Nov 26, 2010 at 12:44 PM, Jagadeesh B S wrote:
> Hello all
>
> I need to prepare the reconciliation report for my company and send it to
> all the person who is responsible f
to populate the values and a macro to integrate Excel and
mailbox so that I can send it to all the people with the data highlighted in
the box above.
Please guide me to write the formulas for myself.
Thanks for looking into it and helping me.
Thanks in advance
Jagadeesh B S
9963025705
Hi all
I see there is some proble with the data only.which needs some changes to be
done.
Thank you so much for the help.
Thanks
Jagadeesh B S
On Thu, Nov 18, 2010 at 7:56 PM, Ajay Varshney
wrote:
> Problem is with the data on the Data tab.
>
>
> Almost all accounts have more
Hello Friends
I need a formula or macro( preferabley formule) need to prepare this report
.
I need a formula which should get the details for the account # mentioned in
the column A with the reference to the currency,form the sheet DATA, if the
currency is USD It should pull the value in the colu
you
Jagadeesh B S
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid
Hi Kalyan pls use Pivot table u can see like the date below.
Count of BP Name - Report Depot Name BP Name - Report Total
Ahmedabad H K Sales Agency - Sanand 1 Parshwa Traders - Gandhinagar 1 Soham
Agency - Chikhli 1 Ahmedabad Total 3 Ambala Chaman Traders - Ambala 1 Happy
Traders
I have an Excel workbook w/ a VBA menu to pops up a userform to write
values back to a worksheet in the workbook. Sometimes, the userform
locks Excel and it has to be abended. I suspect its due to users have
other workbooks open and copying and pasting between them. Can I
specify a specific instan
the data as per the date
> and item.
> Now the only thing to do is to add the following formula in Sheet 2 in
> Column Qty
>
> =VLOOKUP(A4,Sheet1.$B$3:$C$27,2,0)
>
> What this does is it picks the first instance of the Item it encounters in
> the range in Sheet1.(Default fea
Can u tell me how the raw data is arranged so that i can help you better
On Wed, Mar 31, 2010 at 6:36 PM, Shimmy wrote:
> Hello EXCEL_lent people.
>
> I am working for an emerging organisation/company. I would like to
> create a spreadsheet in Excel for my rganisation in which different
> compon
I would like to know whether it is possible to use Application.Run on
a COM command within VBA. I have a test architecture that takes
advantage of the flexibility of Application.Run in its handling of an
arbitrary number of arguments and have found that when the macro name
is a COM (rather than p
1 - 100 of 101 matches
Mail list logo
