I need to write a macro that will scan a range of data, and for any cell in that range of data that has any positive or negative value in it... that it will transpose certain information both from that row and from that column associated with that cell.
More specifically:
If there is a value in range f4:BP66 in worksheet_2 then it needs to take that value and put it in cell A on worksheet_1, it needs to take the value in cell B in the same row in worksheet_2 and put that in cell B in worksheet_1, it needs to take the value in cell A in that same row in worksheet_2 and put it into cell C in worksheet_1, and finally it needs to take the value in Row 3 of the same column of the orginal value in worksheet_2 found in the range (f4:bp66) and put that in cell D in worksheet_1.
After it needs to find the next value in that range and do the same thing for every value and moving it all into worksheet_1 into the next row... and so forth until it has doen this for every value found in that range.
If you think you might be able to help with this and need better info... please let me know.
I really appreciate it!
More specifically:
If there is a value in range f4:BP66 in worksheet_2 then it needs to take that value and put it in cell A on worksheet_1, it needs to take the value in cell B in the same row in worksheet_2 and put that in cell B in worksheet_1, it needs to take the value in cell A in that same row in worksheet_2 and put it into cell C in worksheet_1, and finally it needs to take the value in Row 3 of the same column of the orginal value in worksheet_2 found in the range (f4:bp66) and put that in cell D in worksheet_1.
After it needs to find the next value in that range and do the same thing for every value and moving it all into worksheet_1 into the next row... and so forth until it has doen this for every value found in that range.
If you think you might be able to help with this and need better info... please let me know.
I really appreciate it!
