advanced.excel - Macro

The UK's most regular instructor-led training courses.
Training information: advanced.excel · Advanced.excel · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Macro

Ami-du has attended:
Excel Advanced course

by - delegate Ami-du [2 posts] (2007 Feb 21 Wed, 10:04) Reply

I want to reduce my reconciliation processes to Macro but I keep having different amount of data every month, what can I do?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Macro

by - trainer Jacob gold contributer [106 posts] (2007 Mar 1 Thu, 15:45) Reply

Hi Ami-Du

Thanks for your question. It is tricky to see where you are going wrong without some more detail. Do you have a sample of the code that produces varying results?
It seems the case that you may need to define exactly what you can automate in your reconciliation process before trying to do it.

Rgds Jacob

· How Excel Training Can Improve Your Company's Sales Process
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Microsoft Excel Features and Functions for Accountants
· Basic Excel Training
· 5 Microsoft Excel Charts for Creating Stunning Business Documents

Excel tip:

Colouring cells containing formulas

Cells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells.

Follow these steps:
1. Choose Edit > Go To menu, or press either F5 or Ctrl+G. Excel displays the Go To dialog box.
2. Click Special. Excel displays the Go To Special dialog box.
3. Select the Formulas radio button option.
4. Select OK.

At this point, every formula cell in the worksheet is selected, and those cells can be coloured formatted as desired.

View all Excel hints and tips