Dear Sir / Madam
I have an Excel sheet with VBA which is designed to compare two boxes
of text/copy and highlight any differences. The existing code is very
good although, it does not currently highlight individual words (it
only changes the box color to red to suggest there is an error).
Here is
Hi
I'm trying to work out how I can automate (macro or formula) finding
specific data in a xls and returning the data in a nearby column.
More sepcifically, all the worksheets I'm using include a revenue
total and by this total there is always the text 'ex VAT' (this always
only appears once on a
Hi
I need the following tasks to be automated whenever an additional tab
is opened and data pasted into an Excel 2007 worksheet;
1) Look at a specific cell in the added sheet and dependant on its
contents, add an additional row to one of three sections of a summary
sheet (e.g. if cell = "house" t
Thanks Dilip - I've uploaded the file 'sample.xlsx'
Regards, Greg
On 9 Sep, 15:52, Dilip Pandey wrote:
> Hi Greg,
>
> Please share a sample file with the Group. Thanks
>
> Best Regards,
> DILIPandey
>
> On 9/9/10, gdbar...@googlemail.com wrote:
>
>
Hi Greg,
>
> Please find the attached workbook and let me know if this solves your purpose
> :)
>
> Best Regards,
> DILIPandey
>
> On 9/9/10, gdbar...@googlemail.com wrote:
>
>
>
> > Thanks Dilip - I've uploaded the file 'sample.xlsx'
>
>
