+ Reply to Thread
Results 1 to 4 of 4

inserting a cell field into a statement in another cell

  1. #1
    Registered User
    Join Date
    04-27-2017
    Location
    Silverdale, Wa.
    MS-Off Ver
    365
    Posts
    4

    inserting a cell field into a statement in another cell

    I committed a cardinal sin of sorting a single column instead of the whole spreadsheet. It was then uploaded to a database. The fix seems simple inserting the contents of a cell into a statement in another cell. I can cut and paste but I am sure there is a way to automate it. 1200 lines will take quite a while, and I know this can/will happen again. The statement is " delete from Alias where Alias='XXXXXXXXXXXX' " The Alias is in cells in column "C"
    Attached Files Attached Files

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: inserting a cell field into a statement in another cell

    Hello and welcome to the forum.

    Is this what you are looking for?

    A2 ="delete from Alias where Alias ='"&C2&"'"

  3. #3
    Registered User
    Join Date
    04-27-2017
    Location
    Silverdale, Wa.
    MS-Off Ver
    365
    Posts
    4

    Re: inserting a cell field into a statement in another cell

    That is exactly what I was looking for. I knew it was something easy that I just did not know yet. I really appreciate your help with this.

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: inserting a cell field into a statement in another cell

    You're welcome. Happy to help.

+ 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. inserting comments to cells based on the values of that cell and one other cell (VBA)
    By michaelhowes25 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-07-2016, 06:16 AM
  2. [SOLVED] Inserting value in a cell when element is picked from a dropdown list in another cell
    By adriano.r.marques in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-25-2015, 04:38 PM
  3. Replies: 15
    Last Post: 03-08-2014, 05:19 PM
  4. inserting image to cell/merged cells as background fixed to cell's size.
    By _Rapier_ in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-18-2014, 02:17 PM
  5. Replies: 3
    Last Post: 10-29-2013, 12:06 AM
  6. [SOLVED] Inserting IF Function and depending on answer have cell populate with another cell.
    By Rhiannon25 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-03-2013, 02:17 AM
  7. Replies: 2
    Last Post: 10-29-2012, 10:42 PM

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