mibuso.com

Microsoft Business Solutions online community
It is currently Wed May 22, 2013 12:01 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 7 posts ] 
Author Message
 Post subject: Rec Compare (in Excel)
PostPosted: Tue Mar 10, 2009 10:12 pm 
Offline
Site Admin

Joined: Sun Nov 07, 1999 8:01 am
Posts: 1900
Location: Wilrijk, Belgium
Country: Belgium (be)
Rec Compare (in Excel)
Compare 2 records in MS Excel.

There are 3 ways to do this:
1) Using the tray-icon (right-click)
2) Using an 'always on top' window
3) Using shortcuts

How to compare?
- Copy a record in zoom modus (CTRL + F8)
- Insert record 1 (use step 1,2 or 3)
- Copy another record in zoom modus (CTRL + F8)
- Insert record 2 (use step 1,2 or 3)
- Excel starts.

For suggestions please contact me!

http://www.mibuso.com/dlinfo.asp?FileID=1057

Discuss this download here.


Top
 Profile  
 
 Post subject: Rec Compare (in Excel)
PostPosted: Wed Mar 11, 2009 1:58 pm 
Offline
Site Admin

Joined: Sun Nov 07, 1999 8:01 am
Posts: 1900
Location: Wilrijk, Belgium
Country: Belgium (be)
Rec Compare (in Excel)
Compare 2 records in MS Excel.

There are 3 ways to do this:
1) Using the tray-icon (right-click)
2) Using an 'always on top' window
3) Using shortcuts

How to compare?
- Copy a record in zoom modus (CTRL + F8)
- Insert record 1 (use step 1,2 or 3)
- Copy another record in zoom modus (CTRL + F8)
- Insert record 2 (use step 1,2 or 3)
- Excel starts.

For suggestions please contact me!

Version 11/03/2009:
Small update.

http://www.mibuso.com/dlinfo.asp?FileID=1057

Discuss this download here.


Top
 Profile  
 
 Post subject: Re: Rec Compare (in Excel)
PostPosted: Wed Mar 11, 2009 4:30 pm 
Offline

Joined: Thu Jul 17, 2003 10:52 pm
Posts: 638
Location: Capelle a/d IJssel
Country: Netherlands (nl)
Nice, is the source available ? I want to learn from this for something else. If not ok.

_________________
Create dynamic Excel or Word documents, ReportX


Top
 Profile  
 
 Post subject: Re: Rec Compare (in Excel)
PostPosted: Fri Mar 13, 2009 11:35 am 
Offline

Joined: Thu Jan 03, 2008 3:26 pm
Posts: 25
Country: Netherlands (nl)
ajhvdb wrote:
Nice, is the source available ? I want to learn from this for something else. If not ok.


Done


Top
 Profile  
 
 Post subject: Re: Rec Compare (in Excel)
PostPosted: Fri Sep 11, 2009 12:50 pm 
Offline

Joined: Wed Mar 14, 2007 11:21 am
Posts: 3
Location: Köln
Hi,
sounds like a very useful tool.
But till now I couldn't find out how to use it properly?
I thought to follow the description but there always comes the message "Record is not correct".
What can I do?

Thanks!

Blue


Top
 Profile  
 
 Post subject: Re: Rec Compare (in Excel)
PostPosted: Thu Jun 10, 2010 10:33 am 
Offline

Joined: Fri Nov 14, 2008 5:06 pm
Posts: 119
BlueInTheSky You must press first press Ctrl+F8, Ctrl+c to copy the record in zoom modus. Then you can set it as record 1 or 2 in Rec Compare.


Top
 Profile E-mail  
 
 Post subject: Re: Rec Compare (in Excel)
PostPosted: Fri Jul 09, 2010 11:31 am 
Offline
Site Admin
MVP Microsoft Dynamics NAV
NAV TechDays 2013 attendee

Joined: Sun Nov 07, 1999 8:01 am
Posts: 3293
Location: Wilrijk
Country: Belgium (be)
It would be nice if the lines with changes are marked in a different color (for example in red). Now the cells are displayed in bold.

_________________
No support using PM or e-mail - Please use this forum.
Search is your friend || Mark your Topic as SOLVED (= green checkmark) when your question is answered || Read the Forum Rules before making a posting

»»» Mark your calendar: NAV TechDays 2013 - 7 & 8 November 2013 ««« Visit the conference website: www.navtechdays.com


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 7 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: