Results 1 to 18 of 18

Move Data in Cells based on another cell contents

Threaded View

TimPin Move Data in Cells based on... 08-15-2019, 12:44 PM
Bernie Deitrick Re: Move Data in Cells based... 08-15-2019, 03:16 PM
TimPin Re: Move Data in Cells based... 08-15-2019, 04:30 PM
Bernie Deitrick Re: Move Data in Cells based... 08-15-2019, 04:37 PM
AliGW Re: Move Data in Cells based... 08-15-2019, 04:28 PM
TimPin Re: Move Data in Cells based... 08-15-2019, 04:37 PM
TimPin Re: Move Data in Cells based... 08-15-2019, 04:50 PM
Bernie Deitrick Re: Move Data in Cells based... 08-15-2019, 05:29 PM
TimPin Re: Move Data in Cells based... 08-15-2019, 05:25 PM
TimPin Re: Move Data in Cells based... 08-15-2019, 05:39 PM
Bernie Deitrick Re: Move Data in Cells based... 08-15-2019, 06:12 PM
sktneer Re: Move Data in Cells based... 08-15-2019, 06:44 PM
TimPin Re: Move Data in Cells based... 08-19-2019, 06:06 PM
Bernie Deitrick Re: Move Data in Cells based... 08-20-2019, 10:31 AM
TimPin Re: Move Data in Cells based... 08-19-2019, 06:07 PM
AliGW Re: Move Data in Cells based... 08-20-2019, 10:56 AM
  1. #1
    Registered User
    Join Date
    08-15-2019
    Location
    Oregon, USA
    MS-Off Ver
    Office 2016
    Posts
    9

    Post Move Data in Cells based on another cell contents

    I am withdrawing my request for help from this board. I cannot delete the post so I am changing the text. Amin. Please delete this thread as I am unable to do so. Thank you.

    MOD EDIT: No - we don't remove threads that have responses and you should not post-edit your posts in this way. This is a public forum and information should remain here for the benefit of all, not removed. Please don't do this again - we see it as thread vandalism.

    Original request:


    I have a reservations spreadsheet that I need to transfer data to to another worksheet if a cell is not empty, when an ActiveX button is clicked.

    I need the following to happen when I press the button:

    In Spreadsheet 1 If a cell in I3-I39 is not empty Transfer (append) Data in Cells D, E, F, and G in that row to Columns B, C, D, and E respectively in Spreadsheet 2 then place today's date in column A of spreadsheet 2. Then Delete the data in Spreadsheet 1 Column I ONLY.

    In Spreadsheet 1 If a cell in S3-S39 is not empty Transfer (append) Data in Cells N, O, P, and Q in that row to Columns B, C, D, and E respectively in Spreadsheet 2 then place today's date in column A of spreadsheet 2.Then Delete the data in Spreadsheet 1 Column S ONLY.

    Thank you in advance!
    Last edited by AliGW; 08-20-2019 at 10:47 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to move the contents of one cell based on the contents of another cell:
    By Chad Bateman in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-21-2015, 04:51 PM
  2. Move cell based on contents (VBA)
    By BaronDJB in forum Excel General
    Replies: 5
    Last Post: 12-21-2014, 11:24 AM
  3. Move contents of cells based on condition
    By JR001 in forum Excel General
    Replies: 7
    Last Post: 09-13-2013, 07:35 AM
  4. Macro to move row based on cell contents
    By alpha608 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-17-2013, 04:08 AM
  5. [SOLVED] Move contents of a cell based on contents of another cell
    By djfscouse in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2012, 10:31 AM
  6. Move cell value from one column to another based on contents
    By uncleslinky in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2011, 06:44 AM
  7. Move data between cells based on value of another cell
    By brian0612 in forum Excel General
    Replies: 3
    Last Post: 03-30-2009, 10:59 AM

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