Consulting

Results 1 to 8 of 8

Thread: copy and paste into next blank cell of table

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Nov 2018
    Posts
    21
    Location

    copy and paste into next blank cell of table

    im trying to copy and paste data from one sheet to another to a table that but want it to paste it to the next blank cell and then save the document any tips would help.

    sub CopyRangeFA()
    
    
    
    'Date
      Worksheets("Final Use").Range("D7").Copy
      Worksheets("Log").Range("$D3").PasteSpecial Paste:=xlPasteValues
      Application.CutCopyMode = False
    'Time
      Worksheets("Final Use").Range("D9").Copy
      Worksheets("Log").Range("$E3").PasteSpecial Paste:=xlPasteValues
      Application.CutCopyMode = False
    'SN#
      Worksheets("Final Use").Range("D11").Copy
      Worksheets("Log").Range("$C3").PasteSpecial Paste:=xlPasteValues
      Application.CutCopyMode = False
    'Team Lead
      Worksheets("Final Use").Range("D13").Copy
      Worksheets("Log").Range("$B3").PasteSpecial Paste:=xlPasteValues
      Application.CutCopyMode = False
    
    
    End Sub
    Last edited by Me00550; 04-12-2019 at 06:00 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •