Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a workbook with a "master worksheet" and 4 worksheets that reference all the information in the master. The purpose of the master sheet requires resorting on a quarterly basis. My issue is the format of the referenced cells on the other 4 worksheets. The resort changes the position of the referenced information but it does not pick up all the formats which leaves me with miss matched formats between the master and the other sheets. Can I use a function to reference a cells value and its formats?

share|improve this question
add comment

2 Answers

To specifically answer your last question on whether you can reference a cell's format, the answer is yes, by using the CELL function in your formula.

 =CELL("format", A1)

The values that this function returns are listed on this page:

http://www.techonthenet.com/excel/formulas/cell.php

share|improve this answer
add comment

You could try putting together a hack macro that resets your cell references. If the position changes you'll need to get Excel to locate whatever column/row that you are interested in using some sort of search.

Another way is to leave the master spreadsheet alone and recreate the 4 other guys each time you get an updated master, all with VBA.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.