Hello, I have a spreadsheet with calculations that work correctly but, I want to automate these calculations and be able to do so more then once. I have attached a sample of both data and calculations. As you can see the formulas are starting in cell ac2 or there abouts. I want to start this same routine in say row 30. With my original formulas using $b$2:b3 etc. ranges it will not copy paste and work correctly. Help please.
You've zipped up a shortcut which of course can't be opened remotely
oops sorry when I zipped it I got a message to save to desktop. company just came will finish later.
well here is another attempt at sending zipped file. Hope this is correct as I had to copy data to another sheet I had already zipped and uploaded. Well it has the correct formulas at least in column AF are correct. I did not check other columns.
Last edited by newdude; 10-06-2007 at 02:02 PM.
It might help you to have a look at the INDIRECT function which allows you to assemble a cell reference as a string and get over the problem of an absolute address being completely absolute
thank you for your reply, i am looking at indirect but have not figured out how to use it yet. i entered =indirect ("ac3", "b20") in cell ac 20 and get value error. Still muddling through. will continue in my pursuit.
I have just had another thought on this. will try to use this sheet for calculations and copy/paste data to another sheet. then reset this sheet for next race and so on.
Last edited by newdude; 10-07-2007 at 08:33 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks