LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 46
Default Importing data from .xlsx files

I save a .xlsx file holding results from a data logger each day. The
files are all saved into the same folder.

I have a workbook (Excel 2010) which holds the accumulating data from
rows 10 to 206 in columns A and C in each of these files and which
interprets it.

Rather than have to open the new data logger file each day, manually
copy the relevant columns and rows and then paste them into the workbook
below the previously imported data, I would prefer the task to be
automated. Is this possible in full, or at least partially?

TIA

--
F

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I batch convert 97-2003 .xls files to 2007 .xlsx files Dave Nuttall Excel Discussion (Misc queries) 4 August 3rd 09 11:38 PM
Importing External Data From Several Files Eric O'Connor Excel Discussion (Misc queries) 3 September 15th 06 06:55 PM
Importing data from other files MnO New Users to Excel 4 December 16th 05 08:41 AM
Importing data from text files Jeff Armstrong Excel Programming 3 October 28th 03 01:35 AM
Importing Multiple Data Files steve Excel Programming 0 July 24th 03 09:26 PM


All times are GMT +1. The time now is 08:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"