Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-03-2021, 07:55 AM
allex011 allex011 is offline Help solve problem Windows 7 32bit Help solve problem Office 2007
Advanced Beginner
Help solve problem
 
Join Date: Dec 2017
Posts: 39
allex011 is on a distinguished road
Default 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
Attached Images
File Type: jpg 01.jpg (48.7 KB, 18 views)
Attached Files
File Type: xlsx Multiple values.xlsx (11.4 KB, 13 views)
Reply With Quote
  #2  
Old 08-03-2021, 10:40 PM
ArviLaanemets ArviLaanemets is offline Help solve problem Windows 8 Help solve problem Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

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.
Reply With Quote
  #3  
Old 08-04-2021, 01:05 AM
p45cal's Avatar
p45cal p45cal is offline Help solve problem Windows 10 Help solve problem Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

No attachment Arvi!
Reply With Quote
  #4  
Old 08-04-2021, 05:43 AM
ArviLaanemets ArviLaanemets is offline Help solve problem Windows 8 Help solve problem Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Sorry, here it is!
Attached Files
File Type: xlsx Multiple values.xlsx (16.9 KB, 7 views)
Reply With Quote
Reply

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
Help solve problem 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft