No that didnt work.
i need it to be like "look up table 1, look for next blank in column index 6, then lookup the corresponding number in column 1 and past that number in f4"
Sub Macro3()
'
' Macro3 Macro
'
'
Sheets("Purchase orders ").Select
ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=6, Criteria1:="="
Range("C7").Select
Selection.Copy
Sheets("Purchase Order Request").Select
Range("F4").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("J11").Select
Sheets("Purchase orders ").Select
Range("Table1[[#Headers],[Notes]]").Select
ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=6, Criteria1:="="
ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=6
Sheets("Purchase Order Request").Select
Range("M8").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = " "
Range("K10").Select
End Sub
that was the macro i did but it always brought back the copy from C7 instead of the next blank one because this sort by blanks just hides the rows....
Bookmarks