Consulting

Results 1 to 1 of 1

Thread: Simple VBA: Copy cell data from the top row in below cells (in the respective column)

  1. #1
    VBAX Regular
    Joined
    Jan 2019
    Posts
    14
    Location

    Simple VBA: Copy cell data from the top row in below cells (in the respective column)

    VBA: Copy cell data from the top row in below cells (in the respective column) with ":" sign if the cell is empty.
    Say B1 data is x1* and C1 is empty then the empty cell data will become ":x1*"
    Say G1 data is xx1* and G11 is empty then the empty cell data will become ":xx1*"
    If the top row cell is not empty do nothing. Sheet name is given in VBA code "SheetX" because there are other sheets.
    Last edited by tyavan; 01-05-2019 at 09:25 AM.

Tags for this Thread

Posting Permissions

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