Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #9  
Old 02-18-2019, 02:54 AM
Joanne Joanne is offline Consolidate data from different Excel files Windows 7 32bit Consolidate data from different Excel files Office 2010 32bit
Advanced Beginner
Consolidate data from different Excel files
 
Join Date: Jul 2013
Posts: 58
Joanne is on a distinguished road
Default

I have been having trouble entering the range. When I browse and add the file I want, the file path is longer than the typing area. If I click on the file path and try to arrow along to the exclamation mark, the range appears midway. However, I finally managed to get the four files up with the range in the correct place and the final total is correct but I am getting peculiar dates, eg 28/12/32 instead of 28/04/16. Any ideas?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Move & Consolidate Data meggenm Excel Programming 1 08-27-2017 12:54 PM
Add data from two Excel Files to Word Doc Template nivolaped Word 4 04-10-2016 04:23 PM
Consolidate data from different Excel files Merge the data from different excel files. Sandhya Excel Programming 2 10-10-2015 02:53 PM
Consolidate data from different Excel files Consolidate data from different excel sheets Sandhya Excel Programming 1 10-10-2015 12:28 AM
How to replicate, consolidate and count cell data in excel for data consoldation. Loran Excel 7 06-05-2014 01:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:53 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft