Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Gordy w/Hi Expectations
 
Posts: n/a
Default Excel Spreadsheet from Access. List of names changes as names are

I have a Excel sheet from Access. List of names and other info.
Then I use MS Attendance Sheet and pick up names from the other Excel sheet.
Problem.
When a name is added in Access and the sheet is outputted to Excel it comes
into the Attendance sheet, adding a row for the name but not the whole row so
that the attendance info from the row below becomes info for the new name.

How do I get Excel to add the whole row automatically?
  #2   Report Post  
Gordy w/Hi Expectations
 
Posts: n/a
Default Excel Spreadsheet from Access. List of names changes as names are

I'm using MS template "Weekly Class attendance Record"

"Gordy w/Hi Expectations" wrote:

I have a Excel sheet from Access. List of names and other info.
Then I use MS Attendance Sheet and pick up names from the other Excel sheet.
Problem.
When a name is added in Access and the sheet is outputted to Excel it comes
into the Attendance sheet, adding a row for the name but not the whole row so
that the attendance info from the row below becomes info for the new name.

How do I get Excel to add the whole row automatically?

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
create excel spreadsheet on a data access page Pitu Excel Discussion (Misc queries) 0 October 3rd 05 08:11 PM
Function to List an Excel Workbook's Sheet Names KymY Excel Discussion (Misc queries) 1 April 1st 05 10:47 AM
Excel and Access talking GJR3599 Excel Discussion (Misc queries) 0 March 29th 05 04:59 PM
Sharing information between Access and Excel C.M. Warden Excel Discussion (Misc queries) 1 March 16th 05 12:38 PM
Microsoft Access Report into Excel Spreadsheet zeebyrd Excel Discussion (Misc queries) 1 February 27th 05 12:36 AM


All times are GMT +1. The time now is 12:30 AM.

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

About Us

"It's about Microsoft Excel"