+ Reply to Thread
Results 1 to 3 of 3

If statement and offsets

  1. #1
    Forum Contributor
    Join Date
    08-09-2006
    Posts
    147

    If statement and offsets

    I need a formula to take an entry from one sheet and put into another sheet.

    This sheet is just in the construction stage so please forgive my designing.

    I need a formula that states

    if "Input sheet" B7 is not null then put the amount in "List" sheet on the next empty line.
    I have a macro already to tell me what the next empty cell will be in B1 of Input sheet.

    But, then the next one in B8 needs to go into "List" C8. So, I think I need an offset formula for this one.

    I'm sure there is a more elabrate way of doing this, I just don't have the knowledge.
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: If statement and offsets

    looking at your file, B7 has data validation with 4 values, none of which is a null value, so unless you intend extending the DV, B7 will never contain a null value

    (I know thats not what you were asking for lol, just wanted to point that out...i am working on your request)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor
    Join Date
    08-09-2006
    Posts
    147

    Re: If statement and offsets

    LOL! Yes you are correct. I just want to put whatever is in that cell onto the other sheet. Thanks for pointing that out.

    ---------- Post added at 10:33 AM ---------- Previous post was at 08:12 AM ----------

    I did this macro using the record button. Example: is I want it to copy what is in B7 (null or not null) go to sheet "List" find the end of the data in B1, move over 3 columns and paste. Of course, I will need this for each field in Input Sheet.

    I thought this might help in see what I want to do.

    Please Login or Register  to view this content.

+ Reply to Thread

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