Sirius Black
New Member
- Joined
- Dec 9, 2005
- Messages
- 32
This is an awesome site! First time posting. While I am more than sufficient at using Excel Worksheet functions, VBA is somewhat of a challenge for me. I have a project that I am working on, which requires some VBA code to be written.
I have two sheets, Data & COR. What I want to do is copy data from the Data sheet & paste it into COR. Sounds pretty easy so far. Well, here is one of my problems. The data in the Data sheet will always go from column A to column N. Howerver, the # of rows will vary depending on user selections.
What I'm looking to do, is copy columns A & B from Data (starting with row 4) and paste into columns A & B in COR (the paste should begin in row 9). Column C in COR is a calculated field, calculating the rank of each item. I will need to copy data if column C & D in Data and paste into column D & E in COR. Columns F & G in COR are calculated fields. The formula for cell F10 will point back to cell D10. The formula for F11 will be F10+D11. The formula for F12 will be F11+D12, and so on. The formula for G10 in COR will be D10/$D$9. The formula for G11 in COR will be (D11/$D$9)+G10. The formula for G12 will be (D12/$D$9)+G11, and so on. I will also need to copy from Data, column E and paste into COR column H. Column I in COR will be filled with info from another set of macros that I will need to write. Column J in COR is another calculated field, with the following formula (100-H)*(D-H). Column K, which is the final column in COR, is another calculated field, with the following formula (J*$J$4).
Sorry for such a long description. Thought the more detail the easier it would be to figure out the answer.
Thanks for any and all help!
I have two sheets, Data & COR. What I want to do is copy data from the Data sheet & paste it into COR. Sounds pretty easy so far. Well, here is one of my problems. The data in the Data sheet will always go from column A to column N. Howerver, the # of rows will vary depending on user selections.
What I'm looking to do, is copy columns A & B from Data (starting with row 4) and paste into columns A & B in COR (the paste should begin in row 9). Column C in COR is a calculated field, calculating the rank of each item. I will need to copy data if column C & D in Data and paste into column D & E in COR. Columns F & G in COR are calculated fields. The formula for cell F10 will point back to cell D10. The formula for F11 will be F10+D11. The formula for F12 will be F11+D12, and so on. The formula for G10 in COR will be D10/$D$9. The formula for G11 in COR will be (D11/$D$9)+G10. The formula for G12 will be (D12/$D$9)+G11, and so on. I will also need to copy from Data, column E and paste into COR column H. Column I in COR will be filled with info from another set of macros that I will need to write. Column J in COR is another calculated field, with the following formula (100-H)*(D-H). Column K, which is the final column in COR, is another calculated field, with the following formula (J*$J$4).
Sorry for such a long description. Thought the more detail the easier it would be to figure out the answer.
Thanks for any and all help!