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
> 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
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
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
of
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
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
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,
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
;
>
>
>
>
>
> -Original Message-
> 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
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
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
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
36 matches
Mail list logo