adding another cell line to your speadsheet

[luisjtj]

Hello to all,
I need to know how to add another line to any existing spreadsheet.
Example;
Line 53 Income (existing)
Line 54 abc
Line 55 123
Line 56 Adding a New Line to the existing spreadsheet formula in this spot or any other location within the speadsheet.

Please help.....

Thank you, Luis

 

[MrKowz]

Welcome to the forums!

I'm not quite sure I understand what you are asking. Are you trying to adjust a formula? Type into a cell?

 

[VoG]

Try

Sub InsRow()
Dim Found As Range
Set Found = Columns("A").Find(what:="Income", LookIn:=xlValues, lookat:=xlPart)
If Not Found Is Nothing Then
    Found.Offset(3).EntireRow.Insert
Else
    MsgBox "Not found"
End If
End Sub

 

[luisjtj]

Welcome to the forums!

I'm not quite sure I understand what you are asking. Are you trying to adjust a formula? Type into a cell?

Hi and thanks for responding.
No. I'm trying to add another line from any point of a given speadsheet.
So if these purchase excel templates are already formulated I would like to add another line into the calculations weather in a income line or expense line as an example on a profit and loss statement excel template.

 

[MrKowz]

It sounds like you are wanting to Insert a row.

Try right-clicking on the row and choose "Insert"

 

[luisjtj]

Yes, That is exactly what I'm trying to do. On any given formula of these purchase excel templates. I would like to add in any line to continue adding more incomes or expense line to the existing formula...
In between lines example; Line 53 Line 54 add new line as line 53b or after or before?

 

[MrKowz]

Try the above method I described on line 54.

 

[luisjtj]

Try the above method I described on line 54.

ok thanks... I will.


Thanks for your help.

Luis