+ Reply to Thread
Results 1 to 1 of 1

email row contents based on cell values (google sheets populated by google forms)

  1. #1
    Registered User
    Join Date
    01-13-2016
    Location
    Toronto
    MS-Off Ver
    2013
    Posts
    1

    email row contents based on cell values (google sheets populated by google forms)

    Hi all,

    My coding skills are minimum at best (especially for google docs), and though I've found solutions to bits and pieces, I cannot fit them together to suit my needs. We are using Google Forms by way of inventory control. Staff fill out the online form when removing/replacing inventory from stock. Google Sheets tracks the info and I have set up another worksheet within that workbook to maintain the current inventory, referencing the tracking sheet.
    What I need help with is this:
    Look at column 'G' on the sheet 'Inventory List'
    Find rows that have a value greater than 1
    Populate and send an email to Inventory Control with the information from column A, B, C and G for all rows that have a value greater than 0
    Any help would be greatly appreciated! I have attached the workbook in question in order to remove personal information.
    Thank you very much.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Google image search from cell contents of excel file
    By merQrey in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 07-24-2020, 01:01 AM
  2. VBA Route Calculator - Google Maps Api 22 Minutes quicker than Actual Google Website
    By lookingforhelp1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-06-2015, 01:23 PM
  3. Projected revenue reported based on start day (Google Sheets)
    By djarcadian in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 08-10-2014, 10:09 AM
  4. Replies: 0
    Last Post: 08-10-2014, 10:09 AM
  5. Google (sheets, forms, etc)
    By BRIZZLE101 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 04-03-2013, 08:55 PM
  6. Macro help - use cell contents for Google search
    By tomwsanchez in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2012, 08:26 PM

Tags for this Thread

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