Copying Excel data across 2 separate sheets

[akpetty]

I have a spreadsheet (Work Flow) with data going horizontal from columns F to Q. I am trying to copy this data to a separate spreadsheet (monthly income). This data needs to go vertically. The problem I am having is trying to copy this down vertically. I need the column to change not the cell number. I am trying to reference just the cell. No additional formula. Below is an example of how I need it to transfer. I would like to be able to drag or copy and paste this information and not have to actually reference every cell on the monthly income spreadsheet.

Work Flow Monthly Income
F3 H2
F5 H3
F7 H4
F9 H6
F11 H7

Work Flow Monthly Income
G3 H10
G5 H11
G7 H12
G9 H14
G11 H15

When I copy or drag down the formula to the new columns on Monthly Income it changes the cell number not the column.

Is there a way to get the column to change and not the cell number?

Thank you in advance.

[akpetty]

I have attached a sample worksheet of what I am trying to do. On sheet work flow the data goes horizontal. I need that information to go to monthly income but change the column to correspond with the month which goes vertical.

[newdoverman]

I found the data quite awkward to work with so made an adjustment of the row headers on the Work Flow worksheet to match the row headers on the Monthly Income. This could be done the other way around as long as the headers match exactly. In addition, I filled down the dates on the Monthly Income worksheet and hid the dates added by formatting the text as white. The column headers with the months I edited so that there was a consistent presentation of the months and not a mix of full month names and abbreviations. Doing the above allows the use of INDEX and MATCH to extract the values for the months going across.

Enter this formula in 'Monthly Income'!H2 and fill down then replace the formula in the column for the rows titled "Total: this is your Base for this month" with the amount.

Please Login or Register  to view this content.

[akpetty]

Thank you for the response and help. You solved this problem for me.

[newdoverman]

Thank you for the feedback.

If possible to do so, I would really consider changing the data to proper data format which is Headers for each column (each column is a data field) and 1 row per record. Your data would look much different but would be much easier to work with.