|
|
#1
10-02-2017, 09:05 PM
|
|||
|
|||
Formulas - data from one worsheet to another
Hi all, Thank you in advance......I'm attaching a mock up of a simple staff training register that I'm trying to do (the formatting/drop downs etc i'll worry about later!!). I'm needing the info that is entered into the Register (green tab) in the highlighted columns, to be transferred onto the summary sheet (yellow tab), under the corresponding staff number and category. I'm sure a combination of IF and LOOKUP would be the way to go, but I just can't work out the correct function strings  Appreciate any help.......thanx 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Pasting new data and formulas stop working | ehmo | Excel | 4 | 07-10-2017 01:58 AM |
 Need Multiple Formulas Pulled from a data chart
|
rccolb | Excel | 1 | 03-20-2017 07:42 AM |
|
Formulas transferring to other pages in workbooks, but data isn't.
|
Melissa Ames | Excel | 4 | 03-02-2016 01:58 PM |
|
Formulas/Scripts That Cross Reference & Import Data
|
ekeithjohnson | Excel Programming | 3 | 08-23-2014 11:26 PM |
| If/then formulas with data validation | shira47 | Excel | 1 | 04-09-2012 05:14 AM |
Windows 10 
Office 2010 32bit
Threaded Mode