Hi,
Please see attached. I've got this sheet and using VBA I want to assign a formula to column c. If column b value is equal to "hour" then =a1*8, if column b is equal to Day then =a1 and if column b is blank then do nothing
Hi,
Please see attached. I've got this sheet and using VBA I want to assign a formula to column c. If column b value is equal to "hour" then =a1*8, if column b is equal to Day then =a1 and if column b is blank then do nothing
Last edited by baz0912; 12-01-2008 at 11:41 AM. Reason: poor title and no attachment
Please read our forum rules and then adjust your title according to Rule 1.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
sorry I forgot to attach!
Thanks
Why would you need a macro? A simple IF formula will do this
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I know I can do a formula but I want to be able to click a button and column c to populate. I'm adding the code other code that has been written
Thanks
Try this
bPlease Login or Register to view this content.
Great, thanks for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks