View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ian Ian is offline
external usenet poster
 
Posts: 238
Default Merging Column Data

Looking back to the response to your previous query, I would offer a
modification to one of the lines as follows:

Target.Offset(, 2).Value = 0 - Target.Offset(, 1).Value

--
Ian
--
"Ahh, Excel's Tough" wrote in message
oups.com...
Another problem has been discovered in my Excel Spreadsheet as I have
a dilemna on utilizing two formulas in one box. For example, I want
column C to automatically pop up a certain number of hours when Column
A has a name inserted into it. However, while doing so I also want
whatever number of hours pops up for Column C, I want to subtract
whatever is in Column B from it. Is there any possible way to get this
done, and sorry if this was a little confusing, not really sure how to
describe it other than this.

Thanks!