Transposing + Absolute Reference + Multiple Worksheets = my headache

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


hi there,

been searching around for days literally reading books, manuals, help
guides and going through the excel tips page on here and still can't
find my answer.

I basically have an inventory stock, running on the vertical is the
site names, running along the horizontal is the goods. In the area
inside is the amount of the good at each particular site.

What i need to find out is how I can now transpose this data (flip the
axis) so that i can reference it throughout other worksheets. This
reference must be dynamic, so any changes made on the first *** will
change throughout.

On the *** i am trying to transfer this information to i want the
materials running on the vertical and the sites along the horizontal.

Is there anyway to do this? If i type into my other work***
=***!G10 and then try to drag downwards it will only copy what is on
sheet1 running in the vertical fashion, but what i want it to do is
read the horizontal. Pressing F4 so the $ comes in would work, but
again only if the axis i drag corresponds to the same one i am trying
to copy to, and i would like to reverse the axis.

I would like to try and avoid having to create a pivot table a simple
way to make an absolute reference of a transpose function would be
perfect so long as it can be dynamically entered throughout the
workbook.

I understand this may be slightly confusing, I can post up an example
of what I am working with if need be.

Thanks a lot.:)


--
londar
------------------------------------------------------------------------
londar's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=32970
View this thread: http://www.excelforum.com/showthread.php?threadid=527960

.

Quantcast