mk_alii
New member
- Joined
- Jun 28, 2018
- Messages
- 10
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2013
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!
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!