Multiple found values from five sheets, multiple returned values in sheet six?

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Multiple found values from five sheets, multiple returned values in sheet six?

FAQ

Thread Tools

Display Modes

09-10-2016, 09:03 PM

Philb1

Windows 10 Multiple found values from five sheets, multiple returned values in sheet six?

Office 2010 32bit

Advanced Beginner

Join Date: Feb 2016

Location: Auckland

Posts: 43

Upload an example of exactly what it's supposed to look like after the macro has run. As you have it now every cell will be Value 1, Value 2, Value 3 + the source cell colour etc etc. The macro can copy whatever is in the cell on the source sheets including the colours to the Total sheet, the problem comes with the sorting, especially if you have a mixture of text & numeric.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Display multiple values as new values based on selection from template.	MvdB	Excel	2	09-29-2015 08:51 PM
IF Formula - multiple values	Jac_Fcb	Excel	1	03-17-2015 12:41 AM
Reference another workbook and return values from the same cell across multiple sheets/tabs	lwls	Excel Programming	5	11-08-2014 02:11 PM
I need to add multiple values based on multiple criteria in a cell not sure what to do	AUHAMM	Excel	3	10-27-2014 09:11 PM
carry values of various sheets to another sheet	zizao	Excel	2	06-20-2014 12:47 PM