#1
|
|||
|
|||
Help solve problem
Could someone help me solve this.How if three value insheet1 mach some value from sheet 1,2 or 3 to return value in D column from sheet 1,2 or 3 |
#2
|
|||
|
|||
I think your workbook has backwards design! You enter data on various different sheets, and then want to consolidate them on single sheet. Instead this, consider entering data on single sheet, and having report sheet(s) where you can get data for any designed selection. Attached is an example based on your data (it is an example only - really you can have any report designed in any way you need for which your data entry table has data available).
You can hide columns with brown-colored headers (helper columns), as users don't need to see them at all, and they mustn't have a possibility to edit them. |
#3
|
||||
|
||||
No attachment Arvi!
|
#4
|
|||
|
|||
Sorry, here it is!
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Ideas to solve a folder problem problem ?? | ksor | Word VBA | 11 | 10-24-2019 03:03 AM |
Help solve this problem. | Belise Leavitt | Project | 1 | 02-16-2018 04:32 PM |
Can anyone solve this problem? | ChrisHoppyBot | Office | 0 | 02-20-2013 01:08 AM |
Can anyone solve my problem? | sid44 | Word | 1 | 05-16-2011 09:06 AM |
A problem that is impossible to solve... | A F 1 G 3 | Word | 0 | 09-17-2010 09:32 AM |