CtrlAltRage
New Member
- Joined
- Aug 23, 2022
- Messages
- 12
- Office Version
- 365
- Platform
- Windows
Hey all,
I've scoured the forums and I cannot seem to find an answer to what I'm looking for.
Right now, I have a workbook that contains multiple sheets. The first sheet has a drop down menu where you select a specific option. Then in the cell next to it, I have an IF formula that will populate several referenced cells from another sheet in the workbook.
The formula I'm using for this is:
(In cell D2)
This formula then auto populates the referenced cells into the sheet (7 columns of reference data).
That part works great - but the problem is keeping the formatting of the referenced cells.
I've seen a few examples that are supposed to preserve the formatting when referencing cells, but I cannot seem to figure it out. I'm very new to VBA in excel.
Any help would be great, I appreciate it!
I've scoured the forums and I cannot seem to find an answer to what I'm looking for.
Right now, I have a workbook that contains multiple sheets. The first sheet has a drop down menu where you select a specific option. Then in the cell next to it, I have an IF formula that will populate several referenced cells from another sheet in the workbook.
The formula I'm using for this is:
(In cell D2)
Excel Formula:
=IF('Automated Comparison'!B2="Basic",'Basic (For Reference)'!A2:G11,IF('Automated Comparison'!B2="Pro",'Pro (For Reference)'!A2:G12,IF(B2="Premium",'Premium (For Reference'!A2:G14,IF(B2="Enterprise",'Enterprise (For Reference)'!A2:G17))))This formula then auto populates the referenced cells into the sheet (7 columns of reference data).
That part works great - but the problem is keeping the formatting of the referenced cells.
I've seen a few examples that are supposed to preserve the formatting when referencing cells, but I cannot seem to figure it out. I'm very new to VBA in excel.
Any help would be great, I appreciate it!
