Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 6th 10, 07:42 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 57
Default Import data from one file to another

I have a daunting task of migrating data from old spreadsheets to a new
style. These are attendance records. I'm doing this now by hand, but there's
gotta be a way to automate it. Problem is, while I know Excel quite well, I
don't know macros or VB at all. And the old data is presented very
differently from the new. For example:

An old spreadsheet is a simple list with four columns: Last Name, First
Name, Shift, Date. The new spreadsheets are in a table format, and are much
more advanced. There is a single column for Name, and there are 31 columns
for days where either the AM or the PM shift is entered (P or M), which then
gets counted in the Totals column, and other operations.

Is there any way to ease my work?

  #2   Report Post  
Old January 7th 10, 10:12 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
Posts: 3
Default Import data from one file to another

I'm not sure how to ease most of it but you can at least use the concatenate
function to combine the names. Where A1 is the last name and B1 is the first
name. =concatenate(a1," ",b1) You can switch the order and/or place a comma
or some other seperator in the parenthesis if you want. That should at least
make your first column simpler... Sorry I'm not more help...

mike b

"jmj713" wrote:

I have a daunting task of migrating data from old spreadsheets to a new
style. These are attendance records. I'm doing this now by hand, but there's
gotta be a way to automate it. Problem is, while I know Excel quite well, I
don't know macros or VB at all. And the old data is presented very
differently from the new. For example:

An old spreadsheet is a simple list with four columns: Last Name, First
Name, Shift, Date. The new spreadsheets are in a table format, and are much
more advanced. There is a single column for Name, and there are 31 columns
for days where either the AM or the PM shift is entered (P or M), which then
gets counted in the Totals column, and other operations.

Is there any way to ease my work?



Reply
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
import data from txt file to an existing excel file shaji Excel Discussion (Misc queries) 1 September 12th 09 04:15 PM
Import File Data [email protected] Excel Worksheet Functions 4 March 15th 09 03:19 PM
Import data from zip file through Internet Eric Excel Discussion (Misc queries) 3 December 4th 08 02:34 PM
USING DATA FROM AN EXCEL FILE TO IMPORT INTO ANOTHER Andrew Pickles Excel Worksheet Functions 1 January 17th 07 07:30 PM
import data from a text file jonny365 Excel Discussion (Misc queries) 0 September 6th 05 03:42 PM


All times are GMT +1. The time now is 10:53 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017