If cell is not blank, add it to the cell below. Those cells are linked to another Sheet

[Perguti]

Hello Network,

I'm facing now a task, where I need to linked a cell to another cells, for example:

sheet 1 has a title in B2
Sheet 2 has a column C.

C3 is actually a list where this titles need to appear. fIRST, let say the column C is from 2 until 10 (row)S
So, if I add a title in B2 but in C2 there is already a title (not blanked), then I want that this title appear right below of C2 and so on..
if have tried with

=IF(C2<>""C3,if(C2="",othersheetB2))


thank you!!!

 

[My Aswer Is This]

I believe you would need a vba solution.
I'm not very good with formulas.
But I do not believe this can be done with just a formula.
Are you willing to use a Vba solution.

A script would automatically run when you enter a value in sheet1 Range("B2")
It would be better to give the two sheet names.
Like Mary and Jane
Like sheet1 name is Mary
Sheet2 name is Jane

 

[My Aswer Is This]

If your willing to use Vba solution.
Try this:

This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab Sheet 1
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

Now when you enter a value into Range("B2") of sheet1 that value will now be entered in sheet2 column C

Private Sub Worksheet_Change(ByVal Target As Range)
'Modified  10/3/2018  2:17:09 AM  EDT
If Not Intersect(Target, Range("B2")) Is Nothing Then
If Target.Cells.CountLarge > 1 Or IsEmpty(Target) Then Exit Sub
Dim Lastrow As Long
Lastrow = Sheets(2).Cells(Rows.Count, "C").End(xlUp).Row + 1
Sheets(2).Cells(Lastrow, "C").Value = Target.Value
Range("B2").Select
End If
End Sub

 

[Michael M]

Your thread is a bit confusing, but are you trying to do this ??

=IF(C2="","",C2&Sheet2!C3)

Otherwise, look at MAIT's solution OR post some sample data and how the outcome should look !!