Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I have a daily template that is completed by some team members, this has to be in a format that is easy to read and use for people not used to spreadsheets. However, I need to transfer the data to the main spreadsheet, in a different format so that it can be used to generate reports. I want to use excel as those that will be using the reports don't need to be trained. The input sheet will have a unique date on the form, this is also already present in the main workbook, and will act as the key to link the data extracted to the correct location. The data is in the form of an easy questionnaire, but needs to be translated into a single row of information for each date. The format of the source and destination will not change, but the data will need to be placed against the date row of the destination sheet. So the question is, how do I automatically transfer the information from the first (remembering that there will be around 20 of these each month) to the second (only ever one)? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Getting Data from Excel Graph onto New Speadsheet | Charts and Charting in Excel | |||
How do I copy data from main frame computer and keep data in cell | Excel Worksheet Functions | |||
userform listbox cannot get listbox.value to transfer back to main sub | Excel Programming | |||
Data transfer from a template to a workbook | Excel Worksheet Functions | |||
Access from add_in userform to main template userform.... | Excel Programming |