** Please see attached photos first or have open to better understand description.
Issue 1
Communication between Worksheet 1 "Inventory" and Worksheet 2 "Profit-Loss"
I need data from columns in Worksheet 1 to automatically be manipulated and transferred to columns in Worksheet 2 but only under a certain condition.
More specifically:
Worksheet 1's purpose is to list all of the vital information of all inventory. Worksheet 2's purpose is to express certain criteria(shipping cost, ROI, etc.) of sold inventory items. Worksheet 2 should only calculate inventory items that have already been sold.
I already have certain date calculating and transferring between the sheets but data from all items are being transferred. I only need for the data to transfer if and only if I have indicated that the item has been sold. I am indicating that with a "Y" or "N" in a column labeled "Sold".
Issue 2
Communication between Sheet 4 "Totals" and Sheet 1 "Inventory"
I need data from unsold items("N" in "Sold" Column) from Sheet 1 to calculate and transfer to Sheet 4 in Table "Remaining Listings". Only unsold items' data should be manipulated here.
Quantity(Sheet 4)= Add Unsold items, "N" in "Sold" column(Sheet 1)
Proj. Revenue(Sheet 4)= Add "Appraisal"(column) values for Unsold Items
Initial Investment(Sheet 4)= Add "In. Investment"(column) values for Unsold Items
Format suggestions and general Ideas, suggested improvements are all welcomed and encouraged.
Written solutions to the 2 i