+ Reply to Thread
Results 1 to 2 of 2

Adding All Values ​​Entered Separately In Excel In A Single Cell

  1. #1
    Registered User
    Join Date
    06-15-2021
    Location
    Istanbul/Beylikduzu
    MS-Off Ver
    2019
    Posts
    2

    Question Adding All Values ​​Entered Separately In Excel In A Single Cell

    Greetings,

    I am preparing a self-assessment project for students who are preparing for a YKS exam as in the photo. After selecting the subject from the dropdown menu and entering other data in the menu on the side, I want the data to appear in the table on the side, and I want students to use the features such as conditional formatting, sort of, charts on the table with macros and give information about themselves to people.

    My main question is as follows:
    I have assigned an if function to assign values ​​directly if the subjects are equal on both sides. Example: =IF($B$3=K4;$D$3;0)
    But this time when I change the data in the menu, the data in the table disappears or changes.
    I want to enter each data in the menu, press a button, enter the value according to the subject in the table, and collect the old data when I enter data again and again.

    I will be glad if you can help me with which macro I can do this. This project means a lot to me, Thank you.

  2. #2
    Registered User
    Join Date
    06-15-2021
    Location
    Istanbul/Beylikduzu
    MS-Off Ver
    2019
    Posts
    2

    Re: Adding All Values ​​Entered Separately In Excel In A Single Cell

    Attachment 736626Attachment 736626

+ 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] Code option of placing multiple values ​​in one cell (via a list box)
    By Prangendevraag in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-29-2020, 02:58 AM
  2. Register dynamic values ​​in static values ​​via VBA
    By edneipaula in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-26-2019, 08:57 AM
  3. Replies: 1
    Last Post: 03-25-2014, 10:46 AM
  4. Remove certain values ​​from excel cells
    By public in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-13-2013, 01:53 AM
  5. Replies: 0
    Last Post: 11-27-2013, 09:11 PM
  6. Replies: 7
    Last Post: 11-23-2012, 08:40 AM
  7. [SOLVED] VBA to sum values ​​based on the values ​​in column
    By young_86 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2012, 11:49 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