+ Reply to Thread
Results 1 to 3 of 3

I can't get my data transferred and jump to a new row or recall data

  1. #1
    Registered User
    Join Date
    03-31-2021
    Location
    netherlands
    MS-Off Ver
    2020
    Posts
    4

    I can't get my data transferred and jump to a new row or recall data

    Hello,

    I am trying to make a database and have the following requirements:

    I have a sheet mastertemp, here I want to enter all my NCR data.
    I also have a sheet overview, this where I want my data to go.

    on the mastertemp sheet:
    I want to work with buttons so I made a button to add the date: Range("E9").Value = Now()

    I also want the data I entered to be exported to the overview sheet and clearing the temp for new data. at the same time I want it the row on the overview temp to jump to a new line so I can store new data.
    here is also one of my problems.

    It doesn't work and I don't know how to fix this, this is what I put in:

    Private Sub CommandButton4_Click()
    Sheets("mastertemp").Range("E7").Copy Destination:=Sheets("overview").Range("A2")
    Sheets("mastertemp").Range("E8").Copy Destination:=Sheets("overview").Range("B2")
    Sheets("mastertemp").Range("E9").Copy Destination:=Sheets("overview").Range("C2")
    Sheets("mastertemp").Range("E10").Copy Destination:=Sheets("overview").Range("D2")
    Sheets("mastertemp").Range("E11").Copy Destination:=Sheets("overview").Range("E2")
    Sheets("mastertemp").Range("E15").Copy Destination:=Sheets("overview").Range("H2")
    Sheets("mastertemp").Range("E27").Copy Destination:=Sheets("overview").Range("F2")

    Sheets("overview").Range("A2").Offset(1, 0).Select
    Sheets("overview").Range("B2").Offset(1, 0).Select
    Sheets("overview").Range("C2").Offset(1, 0).Select
    Sheets("overview").Range("D2").Offset(1, 0).Select
    Sheets("overview").Range("E2").Offset(1, 0).Select
    Sheets("overview").Range("F2").Offset(1, 0).Select
    Sheets("overview").Range("H2").Offset(1, 0).Select



    Application.CutCopyMode = False

    'Updateby Extendoffice
    Range("E7").ClearContents
    Range("E8").ClearContents
    Range("E9").ClearContents
    Range("E10").ClearContents
    Range("E11").ClearContents
    Range("E15").ClearContents
    Range("E27").ClearContents

    MsgBox "NCR data transported"

    End Sub


    The last button I made was for a new number that I already have in the next row:2101,2102,2103 to be visible on E7 of the mastersheet so I can fill in a new report under the next number and save it.
    I don't know if this one is not working because of the other button.. but also this one I can't get to work.

    Private Sub CommandButton2_Click()
    Sheets("overview").Range("A2").Copy Destination:=Sheets("mastertemp").Range("E7")
    ActiveCell.Offset(1).Select


    So can someone please help me and explain to me what I am doing wrong?

  2. #2
    Valued Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    445

    Re: I can't get my data transferred and jump to a new row or recall data

    hi,

    give the folowwing a look
    Please Login or Register  to view this content.
    Please be as complete as possible in your asking so it may save use all the time to rework the solution because you didn't give all the requirements. If you have a layout in mind please work it out first so we can adapt our solution to it. Thanks.
    If you have been helped, maybe you could click the *

  3. #3
    Registered User
    Join Date
    03-31-2021
    Location
    netherlands
    MS-Off Ver
    2020
    Posts
    4

    Re: I can't get my data transferred and jump to a new row or recall data

    Joske920,

    This totally fixed the problem!
    Thank you so much!

+ 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. [SOLVED] Data Entry and Recall
    By VBANewbieSBM in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-11-2019, 01:07 PM
  2. [SOLVED] Transferred data overwriting previous transferred data
    By ebanducci in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-04-2019, 04:52 PM
  3. To recall the groups of Data
    By mido21 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-21-2016, 01:30 AM
  4. [SOLVED] Data Transferred to other sheet..
    By krishnakuma6 in forum Excel General
    Replies: 2
    Last Post: 01-25-2015, 09:07 AM
  5. Delete data in listboxes then recall the data without unloading userform
    By Sal1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-11-2011, 06:37 PM
  6. transferred DATA TO ANOTHER SHEET
    By hesham63 in forum Excel General
    Replies: 0
    Last Post: 06-22-2010, 09:26 AM
  7. HI( transferred DATA)
    By hesham63 in forum Excel General
    Replies: 1
    Last Post: 06-21-2010, 03:13 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