Free VBA Training Videos
Get a feed of new tips directly to your outlook
Learn VBA Step By Step
- Introduction to VBA Editor
- Record a Macro
- What does my recorded Macro code mean ?
- FOR Loops
- SUBS and FUNCTIONS explained
VBA Tips and Tricks
- Finding Things Using VBA
- Remove Hyperlinks
- Reset The Used Range
- Screenupdating Make Code Run Faster
- Time Your Code
- Worksheet Events
- Concatenate Range
- Run Code Every Hour, Minute or Second
- Keep Users Informed Of Code Progress - Update Statusbar
- Find The Last Cell
- Get Rid Of Annoying Message Boxes When Closing Excel
- Enable / Disable Events
- Turn Off Message Boxes Whilst Running Code
- Track Changes By Adding A Time Stamp
- Get A File Path
- Save A Copy Of A File Daily
- Write Your Own Excel Function
- Log An Audit Trail
- Import A Text File
- List Files In A Folder
- Pause Code
- Double Click
- Create An Index Page
- Email Workbook
- Call Code From Another Workbook
- Inputbox
- Selecting Things Demo
- Find Out If A Cell Is Within A Range
- Fast Search
- Convert Text To Number
- Smart Table Sorting using VBA
- Turn Off Autofilter
»
- Nick's blog
- Add new comment
- 8606 reads
hi
hello Nick,
i'd like to know how can i build a report which can give me all the items which evoluated between 2 files.
example
file 1
company Sales
ABC 200Euros
bcd 100 euros
File 2
company Sales
ABC 250 euros
bcd 100 euros
here we see an evolution of 50 euros for company abc.
every time i get the latest file, i use VLOOKUP function to determinate if there is a gap.
what can you suggest me?
thanks
Eric
Compare 2 Files
hi Amin
Take a look at this:
Compare 2 Data Sets
Nick