I've Been Digging Through All Of The Archives And Have Come Up Short. I'm A Noob At VBA, But Learning Fast.
I Have A "Cost Sheet" That Has Checkboxes Linked To Cells On That Worksheet. I Am Trying To Create A Macro That Copies The Contents Of Merged Cells Into Specific Merged Cells In The "Purchase Order" Sheet.
The Problem I Have Been Having Is That When The Macro Pastes The Info, It Keeps The Cell Spacing From The "Cost Sheet" & Screws Up The Formatting On The Purchase Order. Here's The Breakdown:
- True / False Boolean In Col A (A6:A28)
- "Cost Sheet" Data To Copy Cols Start: G6, H6, L6, P6, U6, V6, & W6.
- "Purchase Order" Data Placement Cols Start: B20, C20, F20, H20, L20, M20, & N20.
- Press Button On "Purchase Order" & Based On True's In Col A, Copy Rows = True To "Purchase Order"
I Hope That This Is Clear Enough, If Not Please Let Me Know. I've Been Messin With This All Last Week, And I Think My Brain Is Mush. Thanx,
Dustin
I Have A "Cost Sheet" That Has Checkboxes Linked To Cells On That Worksheet. I Am Trying To Create A Macro That Copies The Contents Of Merged Cells Into Specific Merged Cells In The "Purchase Order" Sheet.
The Problem I Have Been Having Is That When The Macro Pastes The Info, It Keeps The Cell Spacing From The "Cost Sheet" & Screws Up The Formatting On The Purchase Order. Here's The Breakdown:
- True / False Boolean In Col A (A6:A28)
- "Cost Sheet" Data To Copy Cols Start: G6, H6, L6, P6, U6, V6, & W6.
- "Purchase Order" Data Placement Cols Start: B20, C20, F20, H20, L20, M20, & N20.
- Press Button On "Purchase Order" & Based On True's In Col A, Copy Rows = True To "Purchase Order"
I Hope That This Is Clear Enough, If Not Please Let Me Know. I've Been Messin With This All Last Week, And I Think My Brain Is Mush. Thanx,
Dustin