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
--
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
> loca
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
an exemple.
André Luiz D´Avila
2015-03-13 10:41 GMT-03:00 B Sharma sharm...@gmail.com javascript::
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
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
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
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
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 has to
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 greater than
Selection.Insert Shift:=xlDown
ActiveCell.Offset(InsQuan, 0).Select
Loop
[A1].Select
Application.ScreenUpdating = True
End Sub
On Fri, Jul 6, 2012 at 5:15 PM, B Sharma sharma@gmail.com wrote:
Dear Excel Experts,
I have a protected data sheet, where I want to insert row where the
cursor
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 few words can do a lot for you
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
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,
I have a protected
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 jainayus...@gmail.com wrote:
Hello Everyone,
Wish you a very happy new year !!
Rajan Verma
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,
Dear friends
thanks for replyinng
But I havrent got my solution
On Dec 3, 11:19 pm, NOORAIN ANSARI noorain.ans...@gmail.com 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 regards
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 any
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
,
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 sharma@gmail.com wrote:
Dear Excel Experts
I want to select
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 important links
-
From: B Sharma
Sent: Thursday, October 13, 2011 8:46 AM
To: MS EXCEL AND VBA MACROS
Cc: rajanverma1...@gmail.com
Subject: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)
Dear Excel Experts (and to my friends who have answered to my
earlier queries)
From a long time, I am
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.
Dear Sanjib.
there is no option there to attach the file
please help
On Oct 12, 12:16 pm, Sanjib Chatterjee chatterjee.kolk...@gmail.com
wrote:
dear
B Sharma
please send me the sheets
sanjib
On Wed, Oct 12, 2011 at 12:37 PM, B Sharma sharma@gmail.com wrote:
Dear Excel
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 chatterjee.kolk...@gmail.com
wrote:
B. sharma.
goto vba = module1=paste the code
in excel write a date = inset the function from userdefined function
a sample 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: MS EXCEL AND VBA MACROS
Cc: rajanverma1...@gmail.com
Subject
...
--
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/groups
Congrats to my lovely friend.. Hey Rajan... carry on your
social work dude.
On Aug 5, 11:08 pm, Manish pansari.man...@gmail.com wrote:
CongratulationsRajan... :)
-
Manish
On Aug 5, 9:37 pm, neil johnson neil.jh...@googlemail.com wrote:
CongratulationRajan.
On
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. Follow us
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 susan.m.ander...@comcast.net wrote:
I useExcel2007 Visual Basic
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
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
32 matches
Mail list logo