Replies

Here’s a copy of the spreadsheet. If you look in cell AK11, you will see where my problem is.

Thanks

Thanks,

Don’t know why when I tried to copy the formula before it didn’t work, but it is now.

One thing I have found with pagebreaks is it makes a difference depending on what is the active cell.

If I want to insert a horizontal page break I need to be in Column A. Being in the pagebreak view helps, but I think it’s more a matter of figuring out why they aren’t working the way you want them to. Unfortunately most of us don’t have the time and just trip over things by trial and error.

Can you suggest a way to just copy just links?

I’ve created a customer spreadsheet that I’ve used to link to a recap spreadsheet. There are numerous links on a few dozen worksheets. The recap spreadsheet will be to compare each of 4 different customers. Once I have the links done, I want to copy them over to the next 3 columns then use find and replace to change the name of the customer spreadsheet. However when I copy it copies the formatting to. I have conditional formatting on most of the cells that read something like this Cell value is greater than or equalt to =+$K$11+$L$13 and cell value is less than or equal to =+$K$11-$L$13. It took me a long time going back and forth making the reference cells absolute or relative depending on whether I was copying the formatting down rows or across columns. If I copy the links then all my conditional formatting has to be redone as find and replace does not look in conditional formatting. It would make my life much easier if I could just paste the links. Values does not work as I want the link.

For starters I would add a column before the salespersons name. You might call it key. In the key column enter OLD beside all those employees who have left. Enter New beside the new ones coming in. The others you can leave blank. Next I would do a data sort. This would move all the old ones to the bottom of the list so you wouldn;t have to keep tabbing over them.

Have you got a sample of your current worksheet?
How do you calculate weeks that finish off one month and start another like Jan 28 – Feb 3?

If you don’t mind the extra work of having to put a header on each page, why not use custom headers. When I use them, I just copy on that I want to repeat on several pages and paste it, but it allows me to have different ones or even a page or two with none.

Thanks John,

I really appreciate your help. I just couldn;t think of a more concise way to show results and you solution is great. What I have to do is be able to show management a number of what ifs, so in addition to the numbers on one page I might show several scenarios where the one bidder zero bids part A, in relation to other possible bids by competitors and what effect if would have on the points. This isn;t the complete picture, but say they barely scraped a pass mark in the quality portion, but zero bid Part A. In most cases that would give them a considerable margin of points in the pricing section. There doesn;t seem to be as much a spread in the quality section, so we might end up with a low quality winner who go there because of their pricing strategy, which is not what we want. I also have to see how they would do in relation to a very high quality bid, that comes with a high price. Obviously we are looking for a good price, but we don’t want the quality to suffer so it’s a juggling act to be able to put a fair and equitable process in place that ensures we get the best of both worlds.

There are also a number of other possible situations…that was just one example…but we have to be prepared for all possibilities and our scoring system has to be defensible so that we aren;t accused of bias for or against any one bidder. Because of the size and nature of the project, all bidders will have spent a great deal of time and money preparing their bids and the ones that don’t win are going to want to know why?

Here’s a sample of just the scenarios….the shaded cells are the ones that change…I have dozens of combinations that I need to try….but need a consise way to show the results…eg low or no bid for A…other bids..low…or other bids a range..