+ Reply to Thread
Results 1 to 10 of 10

Fix data of previous entry in rolling document

  1. #1
    Forum Contributor
    Join Date
    08-10-2006
    Location
    The Netherlands
    MS-Off Ver
    Office for Mac 2016; MS Office 2016 for Windows
    Posts
    110

    Fix data of previous entry in rolling document

    Good day to all,

    I'm running into a problem with attached file.
    First sheet is a daily entry form, 2nd, 3rd, 4th and 5th sheets are rolling documents, pulling the data from the first sheet.

    In the first sheet, only the blue fields are filled with data.
    E1 is invoice number, E2 is invoice date. Other fields are data from that specific invoice.
    Table shown in B4:F11 is pulling the overall data from that first sheet.
    The other sheets in the file are then pulling their respective data from that table (sounds difficult, but is pretty straight forward).

    Now comes the challenge ;-)
    As soon as I enter a new invoice with its specific data, the data in the other sheets is changing as well (as it's linked to the overall table on the first sheet).
    Is there a way that when I enter an invoice with its data, the table on the first sheet is filled, the other sheets are filled as well, but then the data on these 2nd, 3rd, 4th and 5th sheet are e.g. paste as value, so that when I enter another invoice, that specific data is then copied on the next empty line in these sheets?

    I hope I've made myself a bit clear, if not, please feel free to ask!!!

    Thanks all for your help in this, really appreciate it!!

    Kind regards,
    Peter
    veiling.xlsx

  2. #2
    Forum Contributor
    Join Date
    08-10-2006
    Location
    The Netherlands
    MS-Off Ver
    Office for Mac 2016; MS Office 2016 for Windows
    Posts
    110

    Re: Fix data of previous entry in rolling document

    Good afternoon all,

    Just wondering if there is anybody out there with the knowledge to assist me in the above...

    Thanks for the help!!!

    Kind regards,
    Peter

  3. #3
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Fix data of previous entry in rolling document

    Can you tell me where the data should go ?

    Like Sheet1 cell ______ goes to _____ in sheet 2, 3, 4, 5 etc....
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  4. #4
    Registered User
    Join Date
    12-20-2012
    Location
    CA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Fix data of previous entry in rolling document

    have a similar need - data entry cell A1 on sheet1 gets logged on sheet2 in next column A ,B,C with each news entry into A1 on sheet1 = actually more complex but this is the simplied version any help plz

  5. #5
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Fix data of previous entry in rolling document

    mcdojo,

    Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.

  6. #6
    Registered User
    Join Date
    12-20-2012
    Location
    CA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Fix data of previous entry in rolling document

    < newbie sorry

  7. #7
    Forum Contributor
    Join Date
    08-10-2006
    Location
    The Netherlands
    MS-Off Ver
    Office for Mac 2016; MS Office 2016 for Windows
    Posts
    110

    Re: Fix data of previous entry in rolling document

    Hi Arlette,

    Thanks in advance for your time helping me!!! Really appreciate it!!

    I'll try to explain below:
    Sheet 1, cell E1 goes to cell A5 in sheet 2, 3, 4 and 5
    Sheet 1, cell E2 goes to cell B5 in sheet 2, 3, 4 and 5
    Sheet 1, cell C5 goes to cell C5 in sheet 2
    Sheet 1, cell D5 goes to cell D5 in sheet 2
    Sheet 1, cell E5 goes to cell E5 in sheet 2
    Sheet 1, cell F5 goes to cell F5 in sheet 2
    Sheet 1, cell C6 goes to cell C5 in sheet 3
    Sheet 1, cell D6 goes to cell D5 in sheet 3
    Sheet 1, cell E6 goes to cell E5 in sheet 3
    Sheet 1, cell F6 goes to cell F5 in sheet 3
    Sheet 1, cell C7 goes to cell C5 in sheet 4
    Sheet 1, cell D7 goes to cell D5 in sheet 4
    Sheet 1, cell E7 goes to cell E5 in sheet 4
    Sheet 1, cell F10 goes to cell F5 in sheet 4
    Sheet 1, cell F7 goes to cell G5 in sheet 4
    Sheet 1, cell C8 goes to cell C5 in sheet 5
    Sheet 1, cell D8 goes to cell D5 in sheet 5
    Sheet 1, cell E8 goes to cell E5 in sheet 5
    Sheet 1, cell F8 goes to cell F5 in sheet 5

    So far the easy part ;-) The problem I have is that sheet 1 can have different data in above listed cells. When that happens, that data should be copied to the respective cells on the sheets as specified above, only on the next empty line (so line 6, 7 etc) AND saving the previous data transferred from sheet 1 to the line above.

    When I enter in sheet 2, cell A5 "=sheet1!E1", it will move that number from that cell in sheet 1. But when I enter another number in sheet1!E1, it should move that number to sheet 2, cell A6 and saving the previous number in sheet 2, cell A5. Same goes for all the other cells in the table above.
    So in sheet 1, it will only look at the cells I listed above, in sheet 2, 3, 4 and 5, the lines will change with each new entry.

    I hope that the above makes it a bit more clearer... if not, please let me know.

    Thanks again!!
    Peter

  8. #8
    Forum Contributor
    Join Date
    08-10-2006
    Location
    The Netherlands
    MS-Off Ver
    Office for Mac 2016; MS Office 2016 for Windows
    Posts
    110

    Re: Fix data of previous entry in rolling document

    Hi Arlette,

    First of all, best wishes for 2013!!

    Was the above information helpful for you? Or do you require additional info?

    Thanks in advance!

    Kind regards,
    Peter

  9. #9
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Fix data of previous entry in rolling document

    Happy New year to you as well.

    Try this code -
    Please Login or Register  to view this content.
    Copy the Excel VBA code
    Select the workbook in which you want to store the Excel VBA code
    Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
    Choose Insert | Module
    Where the cursor is flashing, choose Edit | Paste

    To run the Excel VBA code:
    Choose View | Macros
    Select a macro in the list, and click the Run button

  10. #10
    Forum Contributor
    Join Date
    08-10-2006
    Location
    The Netherlands
    MS-Off Ver
    Office for Mac 2016; MS Office 2016 for Windows
    Posts
    110

    Re: Fix data of previous entry in rolling document

    Perfect, thanks Arlette!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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