logo elektroda
logo elektroda
X
logo elektroda

Transferring Last Entry Data from SOR to Stickers Sheet in Excel

dbrzust 7770 6
ADVERTISEMENT
Treść została przetłumaczona polish » english Zobacz oryginalną wersję tematu
  • #1 16617778
    dbrzust
    Level 2  
    Hello, I have a problem.
    I got a request to create an Excel file that has several sheets.
    Namely, the point is that the data entered in the sheet "SOR" (or more precisely, each last entry), transferred to the sheet "Stickers" and automatically completed.

    The data to be transferred are:
    First name and last name
    Date of birth
    pesel
    Branch
    General ledger number
    Insurance
    Address.

    The point is that when you introduce a new patient, it automatically filled in the patient's data to the "Stickers" sheet so that they would not have to enter the data manually a second time.

    This is my first post on this page. I am asking for your understanding.

    Attached are screenshots of these sheets
    Transferring Last Entry Data from SOR to Stickers Sheet in Excel Transferring Last Entry Data from SOR to Stickers Sheet in Excel
  • ADVERTISEMENT
  • #2 16618990
    Gmiter
    Level 10  
    I don't know if I understand correctly, but just in case I will write: the simplest way of direct cell reference is not an option? You enter the "=" sign in the target cell, then you change the worksheet, select the cell to be moved and confirm. In this way you link all others. With the right arrangement of rows and columns, you can do it with one drag.
  • ADVERTISEMENT
  • #3 16619269
    dbrzust
    Level 2  
    With the assignment, the cell will not burn permanently, because when a new patient arrives, he will not display it. There must be something such that from each last entry in the "SOR" tab, this data also lands in the "Stickers" tab and repeats in 27 fields (3 columns x 9 lines).

    I can't explain too much, I think :)
  • ADVERTISEMENT
  • #4 16619286
    Gmiter
    Level 10  
    If patient data will be systematically added and "stickers" are also to systematically add (rather than overwrite - and this would be the screens) subsequent values, then permanently linking subsequent cells should fulfill its role.
    More information is needed about the expectations of this solution
  • #5 16619398
    dbrzust
    Level 2  
    It can overwrite, even better if it overwrites. Because they only print these stickers for a given patient once. And how will the new patient get overwritten with the data of the new patient for the previous one, and so on.

    The point is that every new patient should be overwritten in stickers.

    I can attach this bit as needed, maybe it will be more readable than what it is trying to sweat and explain here :)
  • #6 16620141
    JRV
    VBA, Excel specialist
    e.g. for A1 in "Stickers" enter
    = INDEX (ED! C: C COUNTA (SOR! C: C))
    The last row will always be given

    Column D for SOR and almost attention - integrated cells
    then for example A5 will be already
    = INDEX (ED! I: I; COUNTA (SOR! I: I) 1)
  • ADVERTISEMENT
  • #7 16620989
    jackson2002
    Level 9  
    I do not know if I understand correctly
    Sheet 1
    A1 Surname
    B1 Name
    C1 date of birth
    e.t.c

    so to move it to the second sheet of Stickers you do:
    A1 = change to the source sheet and select A1 and give enter
    so that later it is faster you can in the target sheet "catch" the first cell with the mouse and drag down, then all the rest will automatically complete

Topic summary

The discussion revolves around automating the transfer of patient data from the "SOR" sheet to the "Stickers" sheet in Excel. The user seeks a solution to ensure that when new patient data is entered in the "SOR" sheet, it automatically populates the "Stickers" sheet without manual re-entry. Various suggestions are made, including using direct cell references and formulas like INDEX and COUNTA to dynamically link the last entry in the "SOR" sheet to the "Stickers" sheet. The user clarifies that overwriting previous entries in the "Stickers" sheet is acceptable, as stickers are printed for individual patients only once. The conversation highlights the need for a systematic approach to ensure that the latest patient data is always reflected accurately in the "Stickers" sheet.
Summary generated by the language model.
ADVERTISEMENT