Get instant live expert help on I need help with google sheets macro button
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Help testing a macro button on ex 448. Creating macro button
Solved by F. H. in 25 mins
i have a macro w/ button to add a new row within a Range, but i need my formulas and formatting to be withing the new row as well here is my current macro: Private Sub CommandButton1_Click() Sheets("Costing").Range("A9").Select ActiveCell.EntireRow.Insert Shift:=xlDown Sheets("Costing").Range("A9:H9").Select Selection.Borders.Weight = xlThin Sheets("Costing").Range("A9:H9").Se End Sub
Solved by T. J. in 15 mins
Possible to pull in values from Google Adwords into Google sheets, using date range from Google sheets?
Solved by X. W. in 18 mins
HI, I have a spreadsheet with 2 sheets. I want to cut and paste data from one sheet into a new line on a second sheet via a macro button. Lisa.
Solved by Z. E. in 26 mins
In Excel I have a sheet called Client 001 and a button that activates a macro which creates a number of rows then copies a template from another sheet into the new rows. It works great. Now that I have multiple clients however, I find I have to create the same macro for each sheet and change the section in the macro that says Sheets("Client 001").Select to the new sheet name. I have 20+ of the same macro now, making sure each button is assigned the proper macro. Is there an easier way to do this? To be able to use only 1 macro would be great. If I update 1 I now have to update 20+ macros so that all sheets work the same, it's time consuming.
Solved by V. U. in 26 mins