Marcelo Motta
New Member
- Joined
- Jun 3, 2020
- Messages
- 1
- Office Version
- 365
- Platform
- MacOS
Hey there,
I have an excel workbook named All Strategies. There I have several columns (A - U) where I am tracking different things for each cell, all collected at once. That means that all rows value for a given line is collected in the same round, and placed under on the column assigned to that measure. I track over 1000 entries (lines), and the name of the measure I am tracking is written in the line 1 of each row.
Column C is named Strategy, and in that column the following entries are possible: Strategy 1; Strategy 2; Strategy 3; Strategy 4.
When Strategy 1, for example, is filled, I want to copy that entire row to another excel worksheet named Strategy 1 Data located in another workbook named Strategy 1 Full. And of course, I want to do the same procedure to all the other strategies. From this excel worksheet - Strategy 1 Data - I want to copy the entire row to another worksheet - Strategy 1 Float 1 - within that same workbook if the data inserted on column S is lower or equal to 1500. To Strategy 1 Float 2 within that same workbook if the data inserted on column S is between 1500 and 3000, and to Strategy 1 Float 3 within that same workbook if the data inserted on column S is bigger than 3000.
Could somebody help me out, please?
I have an excel workbook named All Strategies. There I have several columns (A - U) where I am tracking different things for each cell, all collected at once. That means that all rows value for a given line is collected in the same round, and placed under on the column assigned to that measure. I track over 1000 entries (lines), and the name of the measure I am tracking is written in the line 1 of each row.
Column C is named Strategy, and in that column the following entries are possible: Strategy 1; Strategy 2; Strategy 3; Strategy 4.
When Strategy 1, for example, is filled, I want to copy that entire row to another excel worksheet named Strategy 1 Data located in another workbook named Strategy 1 Full. And of course, I want to do the same procedure to all the other strategies. From this excel worksheet - Strategy 1 Data - I want to copy the entire row to another worksheet - Strategy 1 Float 1 - within that same workbook if the data inserted on column S is lower or equal to 1500. To Strategy 1 Float 2 within that same workbook if the data inserted on column S is between 1500 and 3000, and to Strategy 1 Float 3 within that same workbook if the data inserted on column S is bigger than 3000.
Could somebody help me out, please?
