have reference cells move in rows while I move in columns
Im filling in data in a table in a worksheet, but the data is coming from another worksheet. But the catch is that the data I'm using to fill, doesn't match the same layout as the table I'm filling. I've attached an example of what I'm talking about, but basically the issue is that if I do the first column by hand, I can't just "drag it over" or copy the formulas because as I move to the right, excel moves the reference cell to the right. Is there any way to tell excel that as I move to the right, the reference cell should move down?
Is that clear? Thanks in advance.
I did not mean to post that yet. The excel file is not useful. I'll repost once it's been fixed
-it should make sense now what I am trying to do
Last edited by gryffin13; 07-13-2011 at 08:42 AM.
Re: have reference cells move in rows while I move in columns
You could use this code:
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1