+ Reply to Thread
Results 1 to 5 of 5

Wenn Zelle Spalte hat Inhalt bitte nimm die nächste Spalte

  1. #1
    Registered User
    Join Date
    09-08-2016
    Location
    England
    MS-Off Ver
    Excel
    Posts
    3

    Question Wenn Zelle Spalte hat Inhalt bitte nimm die nächste Spalte

    Hallo liebe ExpertenINNEN,

    folgendes habe ich (Ausschnit):

    Please Login or Register  to view this content.
    Das Problem ist, dass die Daten (bei erneuter Aussfühung des Macros) gelöscht/überschrieben werden.
    Wie bringe ich Excel dazu, dass: wenn die Spalte B Daten bereits enhält, diese nicht überschrieben werden darf, stattdessen soll die Spalte C genommen werden usw.

    Bin leider kein Excel-Experte.
    Danke im Voraus!

  2. #2
    Registered User
    Join Date
    09-08-2016
    Location
    England
    MS-Off Ver
    Excel
    Posts
    3

    Re: Wenn Zelle Spalte hat Inhalt bitte nimm die nächste Spalte

    Oh this is an english forum, lol!

    OK I want to try it in english:

    Look at the obove code. The problem with this code is, that if cell B has some content, by executing that code the content will be overwritten. How can I say to Excel, if you find some content, please take row C ....

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Wenn Zelle Spalte hat Inhalt bitte nimm die nächste Spalte

    What if B2 has content (it will write in C2) but let say B3 is empty. Shoud next data write in C3 or B3?

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Wenn Zelle Spalte hat Inhalt bitte nimm die nächste Spalte

    Something like this:

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    09-08-2016
    Location
    England
    MS-Off Ver
    Excel
    Posts
    3

    Re: Wenn Zelle Spalte hat Inhalt bitte nimm die nächste Spalte

    Quote Originally Posted by zbor View Post
    What if B2 has content (it will write in C2) but let say B3 is empty. Shoud next data write in C3 or B3?
    Thanks for your answer.
    If B2 is empty then the content should write in B2. That should be the first run of the macro.

+ 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. Excel wenn and funkction
    By excelok123 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-22-2015, 06:28 PM
  2. Replies: 0
    Last Post: 06-12-2014, 01:51 PM
  3. Function =Zelle("Dateiname")
    By Hanspeter W. in forum Excel General
    Replies: 3
    Last Post: 06-24-2006, 06:40 AM

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