Copying empty values

[robbie1974]

I have a workbook with 2 worksheets. The first called import, the second input. My collegue needs to fill in one or more rows on sheet input.

On the import sheet i put in formulas to copy those values and add some more.

When i import my workbook, it is reading all the lines as records even if there is no value.

Purpose is that when I have for example 5 rows on input sheet it only import 5 rows from import sheet.

See attachment.

I don't know vba but maybe what i want can't be accomplished by standard excel?

 

[mrshl9898]

I don't think you can do much more to stop blank rows being imported. Maybe more info about the Importing itself may help there.

One option is to delete everything in import from row 3 down and use VBA to only have the fornulas looking at the rows Inputted:

Sub copytolast()

Dim ws As Worksheet
Dim ws2 As Worksheet
Dim lastrow As Long

Set ws = Sheets("Input")
Set ws2 = Sheets("Import")
lastrow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row

ws2.Range("A2:Co2").Copy ws2.Range("A" & lastrow)

End Sub