"Mirror" Cell Contents elsewhere in a workbook

Thewyzewun

New Member
Joined
Feb 5, 2010
Messages
16
Hi

I'm trying to do two things. One is very simple, and not ideal, the other perhaps slightly harder, but performs the same task as task one much more efficiently.

If I have fill out a few rows in Sheet 1 of a workbook, I'd like the ability to also show that information on Sheet 2.

I've tried entering =CELL(customcellrangename) into an individual cell of Sheet 2, and =(customcellrangename), but in response to either I get #VALUE!.

I've also tried entering =(customercellname) into a particular cell, and can see when I'm referencing an individual cell rather than a cell range (i.e. a selection that includes a few columns and rows) this works fine, I don't understand how to do it with a range though.

That's the simple version, I'm probably just using some syntax wrong.

What I'd really like to do is this:

In Sheet 1 I have rows and rows of data.
In Sheet 2, I want to display the entirety of any row containing the words "Action Required" in Column D. These words will not be mispelt, abbreviated etc so Excel will be able to find them if only I knew how to ask it to look!
To futher complicate matters, data from Sheet 3, Sheet 4 etc will need to be displayed aswell, and I will need some way of telling it apart, so I need to insert the Sheet Name into Column A, preceding each individual row of data.

Like I say, I'm sure I've done this before, but it was so many years ago I've either forgotten or...?

So thanks for any assistance you can offer :)
 
OK, I get a much better picture of what you are doing.

But why do you have data in hundreds of sheets? It seems you want to look at it all at once anyway, and also want to edit it whilst viewing it. What's the total row count for all data combined?
 
Upvote 0

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
OK, I get a much better picture of what you are doing.

But why do you have data in hundreds of sheets? It seems you want to look at it all at once anyway, and also want to edit it whilst viewing it. What's the total row count for all data combined?

Around 10,000 lines. I have data in hundreds of sheets because when I started I only had a few clients, each sheet is client specific. Now I'm trying to manage alot more clients and being able to filter, search, create reports from, etc data would save me alot of time and make everything much more efficient. But I don't have the cash to pay a programmer so I'm trying to muddle through some of it myself. I'm putting this project on the backburner for awhile - I've been spending too much time on trying to get my admin in order and not enough on getting work done (e.g. today it's already 10 to 8 and I won't "finish" til 11pm probably).
 
Upvote 0

Forum statistics

Threads
1,225,149
Messages
6,183,194
Members
453,151
Latest member
Lizamaison

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top