+ Reply to Thread
Results 1 to 7 of 7

[Q] Copy, Store, and Insert Data into another cell.

  1. #1
    Registered User
    Join Date
    09-08-2017
    Location
    Houston, Texas
    MS-Off Ver
    2010, 2016
    Posts
    34

    [Q] Copy, Store, and Insert Data into another cell.

    Hi guys!

    I need help with some VBA. In my sample workbook I would like for data in worksheet RAW cell B7 to be copied / stored if cell is not empty. In worksheet COPY cell B6 the data is then retrieved. In my actual workbook the row for "charges" changes based on invoices for the week thus the vlookup.

    Any help would be appreciated!
    Attached Files Attached Files
    Last edited by huyza_0100; 01-30-2018 at 05:39 PM.

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: [Q] Copy, Store, and Insert Data into another cell.

    Hi huyza_0100

    to be copied / stored if cell is not empty
    Cell will never really be empty if it contains a formula...

    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Registered User
    Join Date
    09-08-2017
    Location
    Houston, Texas
    MS-Off Ver
    2010, 2016
    Posts
    34

    Re: [Q] Copy, Store, and Insert Data into another cell.

    hmmm. I just tried the snippet out and it didn't do anything. Did I do something wrong?

  4. #4
    Valued Forum Contributor
    Join Date
    09-01-2013
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2010
    Posts
    324

    Re: [Q] Copy, Store, and Insert Data into another cell.

    Can you help me understand why you don't just use the below formula in B6 on the copy sheet? I need to understand the full scope of what you're trying to accomplish and your request seems a little bland to specifics.


    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Shelton A.
    If Helpful, Add Reputaion!

  5. #5
    Registered User
    Join Date
    09-08-2017
    Location
    Houston, Texas
    MS-Off Ver
    2010, 2016
    Posts
    34

    Re: [Q] Copy, Store, and Insert Data into another cell.

    Maybe I wasn't clear enough in my first post.

    I copy and paste a billing invoice into the raw worksheet weekly. In one particular line it'll have "CHARGES". As with any invoice, items may vary and the "CHARGES" line may move between rows weekly. I use VLOOKUP to find which rows it's located and extract the number the column over. In the event that I switch or delete the entire raw invoice. I would like for the data to be stored and copied to another cell thus "if the cell value is not empty".

  6. #6
    Registered User
    Join Date
    09-08-2017
    Location
    Houston, Texas
    MS-Off Ver
    2010, 2016
    Posts
    34

    Re: [Q] Copy, Store, and Insert Data into another cell.

    Okay, so I took sintek's code and changed it to when the worksheet state changes and it worked as intended.

    Please Login or Register  to view this content.

  7. #7
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: [Q] Copy, Store, and Insert Data into another cell.

    Glad you got it sorted...Thanks for rep added...

+ 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. Create a Macro to copy and paste data to store it permanently from a changing table
    By ronakpatel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-22-2017, 01:01 PM
  2. [SOLVED] Insert row based on cell content and copy data across, matching headings
    By ris1909 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-30-2017, 08:15 PM
  3. [SOLVED] Dynamic Changing Data, Based on Criteria Store in Array, Sum array and store in Cell
    By penbeacho in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-28-2015, 10:31 AM
  4. Copy cell data and insert into another worksheet based upon cell
    By cory99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-22-2013, 08:37 AM
  5. Store/copy/save cell values to another workbook
    By notquitetheguru in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2013, 07:04 AM
  6. Cell copy the data to another cell and insert a blank row
    By dpatel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-30-2012, 04:38 AM
  7. Copy and store cell value changing every 5 seconds
    By fcc05 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-09-2009, 05:08 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