Re: worksheet

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:52 PM GMT

Question

I have a VAT worksheet exported from Quickbooks 2006 as such:- Oct 2010 worksheet. A1 B1 C1 D1 E1 F1 Date Type Details Amount VAT(16%) (running

                                               totals)

12/10 Bill KENYA WOOLS 1000.00 160.00 13/10 Invoice INTERWOOD -10000.00 -1600.00 14/10 Cash sale KISUMU MILLS -5000.00 -800.00

Now as you may know, Quickbooks does not take into account pending sales into the VAT element until made finalised, so then the VAT comes into account.see 4th item below, which is now appearing in October 2010(2) (done in November 2010) worksheet. A1 B1 C1 D1 E1 F1 Date Type Details Amount VAT(16%) (running

                                               totals)

12/10 Bill KENYA WOOLS 1000.00 160.00 13/10 Invoice INTERWOOD -10000.00 -1600.00 14/10 Cash sale KISUMU MILLS -5000.00 -800.00 16/10 Cash sale MOMBASA BREWERY -15000.00 -2400.00 Now , i have like 500 rows, is there a way to highlight what has come additional into my OCtober 2010(2) worksheet discerning it from from my October worksheet. Its like minusing the contents of October 2010 worksheet from October 2010(2) worksheet. & leaving behind only the contents that have been included in October(2) 2010 worksheet.Either through color or bold captions or otherwise.The format will remain the same.



Answer

First of all sorry for the delayed reply, since there was some problem in my internet connection.

It will be very much understandable and give solution, if you send your file to my personal mail id.

My mail id: ms.exl.expert@gmail.com

1) Detailed query with sheet, Column & cell references. 2) what you would like to get from it 3) How you would like to derive the answer (Method in which basis) 4) What should be the expected answer and where it is required.

Please clarify the above to give you better solution while sending the file.

Advertisement

©2021 eLuminary LLC. All rights reserved.