Search results

Hi Apologies if this has been covered elsewhere, Am new to vba macros, and i'm struggling to find an answer. I have a table range in Excel called Objectives. I want to assign a macro to a command button that will add a new row to the bottom of the table each time it is clicked. Id also like...

Hi I am trying to create very basic dashboard with the following graph. It works fine but I was wondering if it was possible to reformat the button in the top left so it looked a bit nicer? Cheers Marc

I have a simple chart that pulls data from a pivot table using the getpivotdata formula., this works fine for the row values but it isn't pulling anything through for the grand total. Column A pulls the row value from the pivot table ='Pivot - Recruitment'!BY12 then the second column used the...

I hvae a spreadsheet used for logging employee relations cases. It alsready has the following VBA applied to it. Help on this was very kindly given on this forum at the time. i now have to add an additional column which must only be mandatory if a certain value (Grievance) is selected in column...

I had a spreadsheet which has the following vba query set upinthe This Workbook Apart from the opening message and it openeing inthe 1st column. The VBA applies so that the 1st 14 fields in a row must be completed once data is entered into column A. as this spreadsheet has evolved ive been...

Hi I amm new to VBA and have managed to patch something together from various excel forums. I have a case management spread sheet which has a number of rows. The first 9 are mandatory when the spread sheet is 1st completed. Users can subsequently complete the rest of their row as the issue...