Results 1 to 1 of 1

Thread: VBA Code To Change Cell Text & Drag Row Down?? Help!!

  1. #1
    Seeker mk_alii's Avatar
    Join Date
    Jun 2018
    Posts
    10
    Articles
    0
    Excel Version
    Excel 2013

    VBA Code To Change Cell Text & Drag Row Down?? Help!!



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Guys!

    I was wondering if it was possible to have VBA Code (linked to a button) change the text within a cell? (change a single number within a cell)
    Also a different VBA code that can drag a row down automatically?

    Background:
    I have a large excel sheet for reporting my team’s monthly metrics. This Excel workbook is linked to our companies Oracle DB. Currently, once a month I “refresh all” to update this Excel workbook and it automatically produces the metrics required. (This is done via SQL Query)

    I have a manual task within this excel workbook where I must change the date of the month as well as drag a table down to update the graph.
    Shown in screenshots

    The locations for the cell needing changed text is 'Overall Performance' cell F1
    The rows are located at 'Overall Performance' Columns A-D

    Thanks in advance for your guys' help!
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	1.JPG 
Views:	9 
Size:	14.3 KB 
ID:	8220   Click image for larger version. 

Name:	2.JPG 
Views:	8 
Size:	16.0 KB 
ID:	8221  

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
  •