If then statement help needed

[pawcoyote]

Greetings,

I am trying to do the following but I am a novice with formulas...

BR Could be either Add, Drop or Change... If it is Add or Drop I need to do the copy and combine if it is Change I don't need to do anything.


MASTER Sheet
BR2= ADD
Copy F2, H2, I2, J2, K2, L2, BR2
ADDENDUM Sheet
A2, B2, C2, D2, E2, F2, I2

MASTER SHEET
AND COMBINE AA2, AB2, AC2
ADDENDUM SHEET
G2

Thanks for any help you can provide.

[pinball4530]

I don't understand what you want.
Copy to what to where? Combine what and to where?

[FDibbins]

to best describe your question, please upload a sample work book (remove any confidential info if necessary). Your file should show what your data looks like, a sample of your expected outcome, and how you arrived at that. Thanks


To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.