TripletDad
Board Regular
- Joined
- Oct 19, 2010
- Messages
- 121
I'm hoping somebody out there can either create a macro, or help with a formula that will save me hours upon hours of work. This is a confusing stuff, but hopefully I can spell it out enough to get some help...
I manage a bunch of data in a massive Excel spreadsheet. Unfortunately, I can't input the data all at the same time (it has to pass through different "gates" internally) so, once all the data is populated, I'd like to fill in the last field "automatically" ... maybe through a macro?
I have a spreadsheet that is about 15k rows by 80 columns. For this project, I only need to reference three columns so I can populate the fourth.
Column A = SKU
Column C = Product Type
Column E = Parent ID
Column F = Child ID
Basically, I need to use the data in Column A, C & E to populate Column F.
In English, the macro needs to say "If Column C says anything other than "Simple" or "Simple Simple", then look at Column A and Column E. If Column E matches Column A, then put that value of Column A in Column F. If multiple matches are found, separate the values with a pipe "|".
So, in the example below, the last column (labeled Column F) would be empty before the macro is run.
After it is run, the following happens.
F3 is populated with "92104" because Column A & E match and "91204" is in Column A.
F4 is populated with "895586|895587|895588|895589|895590|895591|" because Column A & E match and those are the values of column A, separated by pipes.
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
I manage a bunch of data in a massive Excel spreadsheet. Unfortunately, I can't input the data all at the same time (it has to pass through different "gates" internally) so, once all the data is populated, I'd like to fill in the last field "automatically" ... maybe through a macro?
I have a spreadsheet that is about 15k rows by 80 columns. For this project, I only need to reference three columns so I can populate the fourth.
Column A = SKU
Column C = Product Type
Column E = Parent ID
Column F = Child ID
Basically, I need to use the data in Column A, C & E to populate Column F.
In English, the macro needs to say "If Column C says anything other than "Simple" or "Simple Simple", then look at Column A and Column E. If Column E matches Column A, then put that value of Column A in Column F. If multiple matches are found, separate the values with a pipe "|".
So, in the example below, the last column (labeled Column F) would be empty before the macro is run.
After it is run, the following happens.
F3 is populated with "92104" because Column A & E match and "91204" is in Column A.
F4 is populated with "895586|895587|895588|895589|895590|895591|" because Column A & E match and those are the values of column A, separated by pipes.
* | A | B | C | D |
1 | Column A | Column C | Column E | Column F |
2 | SKU | Product Type | Parent ID | Children ID |
3 | 92103 | Grouped | NA | 92104 |
4 | 92104 | Configurable - Part of Group | 92103 | 895586|895587|895588|895589|895590|895591 |
5 | 895586 | Simple | 92104 | NA |
6 | 895587 | Simple | 92104 | NA |
7 | 895588 | Simple | 92104 | NA |
8 | 895589 | Simple | 92104 | NA |
9 | 895590 | Simple | 92104 | NA |
10 | 895591 | Simple | 92104 | NA |
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4