Using this formula =IF(ISBLANK(A1),"",A1) to autocopy a set of numbers in my worksheet,
the trouble is I then need to click on the copied cell to subtract/add how can i do this without clicking on the cell and displaying the formula.
Using this formula =IF(ISBLANK(A1),"",A1) to autocopy a set of numbers in my worksheet,
the trouble is I then need to click on the copied cell to subtract/add how can i do this without clicking on the cell and displaying the formula.
What are you trying to do? why are you having to click on a results cell to add or subtract, can you not just pre define another formula to include that cell if there's data within? can you upload a sample?
Last edited by NBVC; 12-15-2010 at 02:27 PM. Reason: Deleted quoting of entire post
Windows 7 using Office 2007 & 2010
Remember your [ code ] [ /code ] tags, makes reading soooo much easier
As I type in collums G&H it auto copys using the formula in to collums K&L i want to then click on the cells in K&L to add and subtract specific numbers. XLS attached sheet 5
Any Ideas???
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks