Hi All:
Here is the file I need your help on:
I have setup the spreadsheet so that the current section contains the a block of data I need a macro to convert into the desired outcome.
Can you please help me build a macro that will do the following for me:
1. In the current section, if A3 contains an order number (i.e. 700027). I need A3:C3 to be replicated in A4:C4. But I need the macro to do this wherever an internal order number is found. So A6 contains an order number so replicate A6:C6 in A7:C7.
2. Now the next thing I need the macro to do is put in the word "Budget" in cell D12 and the word "actual" in cell D13 if the an internal order number is located in cell A12. I also need the macro to repeat the process in the same way if an order number is found in column.
Thanks so much in advance for your help on this,
Bharat
Here is the file I need your help on:
Book2 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
2 | Current | |||||||
3 | 700027 | 5133000 | COS:contractclean | 270 | ||||
4 | 1,510 | |||||||
5 | ||||||||
6 | 700028 | 5133000 | COS:contractclean | 540 | ||||
7 | 0 | |||||||
8 | ||||||||
9 | 700356 | 5133000 | COS:contractclean | 2,050 | ||||
10 | 417 | |||||||
11 | Desired | |||||||
12 | 700027 | 5133000 | COS:contractclean | Budget | 270 | |||
13 | 700027 | 5133000 | COS:contractclean | Actual | 1,510 | |||
14 | ||||||||
15 | 700028 | 5133000 | COS:contractclean | Budget | 540 | |||
16 | 700028 | 5133000 | COS:contractclean | Actual | 0 | |||
17 | ||||||||
18 | 700356 | 5133000 | COS:contractclean | Budget | 2,050 | |||
19 | 700356 | 5133000 | COS:contractclean | Actual | 417 | |||
Sheet1 |
I have setup the spreadsheet so that the current section contains the a block of data I need a macro to convert into the desired outcome.
Can you please help me build a macro that will do the following for me:
1. In the current section, if A3 contains an order number (i.e. 700027). I need A3:C3 to be replicated in A4:C4. But I need the macro to do this wherever an internal order number is found. So A6 contains an order number so replicate A6:C6 in A7:C7.
2. Now the next thing I need the macro to do is put in the word "Budget" in cell D12 and the word "actual" in cell D13 if the an internal order number is located in cell A12. I also need the macro to repeat the process in the same way if an order number is found in column.
Thanks so much in advance for your help on this,
Bharat