Thanks porucha
I am just a simple Newbee in VBA so I don't know what you meen?
Can you explain please.
I have put the code I have below so far.
Sub LoopThroughTables()
'PURPOSE: Loop through each table in the Sheet("BEREGNING") and copy values in Column("A") and paste in Sheet("Tilbud2")
Dim Table As ListObject
Dim SourceSheet As Worksheet
Dim TargetSheet As Worksheet
Dim LastRow As Long
'Set Sheets As Source and Target Sheet (Copy and Paste)
Set SourceSheet = ThisWorkbook.Worksheets("BEREGNING")
Set TargetSheet = ThisWorkbook.Worksheets("TILBUD2")
'Find last Row with Data
LastRow = TargetSheet.Range("A" & Rows.Count).End(xlUp).Row
'Loop through each table on a sheet
For Each Table In SourceSheet.ListObjects
'Find TableHeader and copy
SourceSheet.ListObjects("table" * "").HeaderRowRange.Copy
'Paste TableHeader in TargetSheet, Find lastRow with Data from ("TableValuesFromSheets") and Offset(3, 0)
'("TableValuesFromSheets") is TargetSheet.Range("A9")
TargetSheet.Range("TableValuesFromSheets").End(xlUp).Offset(3, 0).PasteSpecial xlPasteValues 'Font.Bold = True
'Copy Column"A" in DataBodyRange
Table.ListColumns(1).DataBodyRange.Copy
'Paste Value from Column "A" in DataBodyRange in TargetSheet, Find lastRow with Data from ("TableValuesFromSheets") and Offset(1, 0)
'("TableValuesFromSheets") is TargetSheet.Range("A9")
TargetSheet.Range("TableValuesFromSheets").End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues 'Font.Bold = False
Next Table
'Do rest of the code
End Sub
Bookmarks