Spreadsheet Links have me stumped!

  • Thread starter Thread starter nander
  • Start date Start date
N

nander

Okay, got this somewhat elaborate spreadsheet and I need help big time!
In this spreadsheet there are 4 worksheets. Products / AC SPECS / AC-JS
/ AC-DEALER. the Products worksheet holds SKU data & AC SPECS worksheet
holds System combinations. My problem is in the AC-JS and AC-DEALER
worksheets. In the AC-JS worksheet I need the TE column pricing based
on data from the Products worksheet column G. the T1 column pricing
based on the data from the products worksheet column Lot 1. the T2
column based on the data from the products worksheet column Lot 2. the
TS column based on a 12.5% gross margin. see formula. I then want to do
the same thing in the AC-DEALER worksheet. the 1.08 in cell V1 in
worksheets AC-JS and AC-DEALER is the tax rate. some customers want
systems price sheets with or without tax. Thanks.
 
I've uploaded the file I'm working with. It was too large when I first
placed the post. I'm sure its a simple solution I just can't see it at
the moment.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Circular Reference - Why? 7
Excel formulation to automate values 3
Multiple criteria over Multiple sheets 1
Trying to combine 2 Worksheets 1
Sum if two conditions met 3
Assistance with VBA and drop down list 0
Sorting data on one sheet, linked to another, but staying the same 1
Linking Separate Spreadsheets Together 2

Back
Top