Mastersheet

S

srctr

I am creating a master sheet and I have that it creates a list of sheet names
then use indirect to reference sheet names and the appropriate cell in the
sheet. Can I add text to the equation? For example the equation
=INDIRECT("'"&A5&"'!B39") gives me my Invoice Number from that worksheet -
225. But I would like to add to it the text "Invoice# OSC-00"

So that my answer would be Invoice #OSC-00225
 
D

Don

you should be able to add at the begining of your formula

="Invoice# "&

and put the indirect part after
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top