Help multiple sheets in one sheet

		Microsoft Office Forums > Microsoft Excel > Excel
Help multiple sheets in one sheet

FAQ

Thread Tools

Display Modes

03-13-2020, 06:41 AM

NoSparks

Windows 10 Help multiple sheets in one sheet

Office 2010

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

Quote:

how to in one sheet place values from different sheets (30 row for each sheet).

Based on that much information, copy and paste as values.

Quote:

Also is it possible to have that in sheet that collect values, hide empty cell but when cells in multiple sheet are filed, hidden cell are visible again

What do you mean by that?
To my knowledge you can hide a row (16,384 cells) or a column (1,048,576 cells) but not single cells.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple found values from five sheets, multiple returned values in sheet six?	irisha	Excel Programming	26	09-30-2016 01:20 AM
Complex calculation from multiple sheets to master sheet	inreality01	Excel	49	01-06-2016 03:09 PM
Need help in automating data from multiple sheets into a single sheet	veedee	Excel Programming	8	06-12-2014 10:04 PM
Need help in automating data from multiple sheets into a single sheet	veedee	Excel	1	06-11-2014 04:01 AM
How do I merge data from one sheet in a workbook out into multiple sheets	nolesca	Excel	4	06-07-2010 08:13 AM