I use excel and I am not very good at writing VB so hopefully this makes since to someone. Any help would be greatly appreciated!!
I have a worksheet that has six columns, BU,GL Acct, Descr,OU,Ledger and Amount. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Data looks like this: Worksheet1<o></o>
<o></o>
BU GL Acct Descr OU Ledger Amount<o></o>
<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /><st1:stockticker>NNN</st1:stockticker> 234567 Asset 10030 ACTUALS 2500<o></o>
<st1:stockticker>NNN</st1:stockticker> 234567 Asset 10030 INGGAAP 1500<o></o>
<st1:stockticker>NNN</st1:stockticker> 234567 Asset 10030 STATUTORY 3500<o></o>
<st1:stockticker>NNN</st1:stockticker> 234567 Asset 10030 USGAAP 4500<o></o>
<st1:stockticker>NNN</st1:stockticker> 234567 Asset 10030 IFAS 7500<o></o>
<st1:stockticker>AAA</st1:stockticker> 244554 Asset 10035 ACTUALS 3000<o></o>
<st1:stockticker>AAA</st1:stockticker> 244554 Asset 10035 INGGAAP 5000<o></o>
<st1:stockticker>AAA</st1:stockticker> 244554 Asset 10035 STATUTORY 7000<o></o>
<o></o>
I need to copy rows based on criteria that = column A, column B and column D are the same to worksheet 2. this needs to happen all the way through worksheet 1.<o></o>
<o></o>
Then in worksheet 2 their are five new columns starting in column H thru K. The names for these columns are ACTUALS, INGGAAP, STATUTORY, USGAAP and IFAS.<o></o>
<o></o>
Based on column E (Ledger), if the cell = ACTUALS then the Amount (Column F) for that string will be placed in the first row under that column name = ACTUALS and so on.<o></o>
<o></o>
Worksheet should look like this:<o></o>
<o></o>
BU GL Acct Descr OU Ledger Amount ACTUALS INGGAAP STATUTORY USGAAP IFAS <o></o>
<st1:stockticker>NNN</st1:stockticker> 234567 Asset 10030 2500 1500 3500 4500 7500<o></o>
<st1:stockticker>AAA</st1:stockticker> 244554 Asset 10035 3000 5000 7000 <o></o>
I have a worksheet that has six columns, BU,GL Acct, Descr,OU,Ledger and Amount. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Data looks like this: Worksheet1<o></o>
<o></o>
BU GL Acct Descr OU Ledger Amount<o></o>
<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /><st1:stockticker>NNN</st1:stockticker> 234567 Asset 10030 ACTUALS 2500<o></o>
<st1:stockticker>NNN</st1:stockticker> 234567 Asset 10030 INGGAAP 1500<o></o>
<st1:stockticker>NNN</st1:stockticker> 234567 Asset 10030 STATUTORY 3500<o></o>
<st1:stockticker>NNN</st1:stockticker> 234567 Asset 10030 USGAAP 4500<o></o>
<st1:stockticker>NNN</st1:stockticker> 234567 Asset 10030 IFAS 7500<o></o>
<st1:stockticker>AAA</st1:stockticker> 244554 Asset 10035 ACTUALS 3000<o></o>
<st1:stockticker>AAA</st1:stockticker> 244554 Asset 10035 INGGAAP 5000<o></o>
<st1:stockticker>AAA</st1:stockticker> 244554 Asset 10035 STATUTORY 7000<o></o>
<o></o>
I need to copy rows based on criteria that = column A, column B and column D are the same to worksheet 2. this needs to happen all the way through worksheet 1.<o></o>
<o></o>
Then in worksheet 2 their are five new columns starting in column H thru K. The names for these columns are ACTUALS, INGGAAP, STATUTORY, USGAAP and IFAS.<o></o>
<o></o>
Based on column E (Ledger), if the cell = ACTUALS then the Amount (Column F) for that string will be placed in the first row under that column name = ACTUALS and so on.<o></o>
<o></o>
Worksheet should look like this:<o></o>
<o></o>
BU GL Acct Descr OU Ledger Amount ACTUALS INGGAAP STATUTORY USGAAP IFAS <o></o>
<st1:stockticker>NNN</st1:stockticker> 234567 Asset 10030 2500 1500 3500 4500 7500<o></o>
<st1:stockticker>AAA</st1:stockticker> 244554 Asset 10035 3000 5000 7000 <o></o>