Results 1 to 7 of 7

if cell i is not enpty then enter "text"or data in cell m and count

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    772

    if cell i is not enpty then enter "text"or data in cell m and count

    hi
    i have a spreadsheet with data with collumns a to q and rows 3 to say 30,not sure if all can be done with conditional formatting or macro
    what i would like to achieve is ,this is a stock take sheet,if cell i has data in in it then populate cell m with a number 1,when this item is used and returned the number in cell m should increase by 1,so at the end of the month i can see how many times this item has been taken out and returned,if no number it has not been issued, i already have code to highlight empty rows, its just if cf can enter numbers in cell or vba the way to go,any pointers would be good have read that many threads today my heads spinning
    cheers colin
    Last edited by cfinch100; 05-23-2013 at 01:04 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1