Search results

Hi Thanks for your reply what i was after is linking the command to a button people could click on to create a row to the table using a button as per the attached file and keep the row formatting in place. Marc

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...

That could be an option. Ideally id want to format the actual button itself but if this is not possible then using the pivot filter could work.

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

Hi thanks for this. think I've resolved this with the help of a colleague for this month at least =IFERROR(GETPIVOTDATA("Previous Company",'Pivot - Recruitment'!$BY$4),0) As the pivot table grows not sure if this will work so will look at the link above in more detail if this is the case

Thanks for this Only issue might be is as time goes on there may be additional rows so was hoping a formula could be used that took this into account without having to have manual intervention each month To put it into context its used to track new hires and what companies they have come from.

Hi Luke. That's what I was trying to find out. Can't post a sample I'm afraid. What I need to know is what is the right formula to use to pull the grand total from a pivot table. 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...

Dont think i can do that unfortunately

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...

Thanks again for your help!

Narayan, Thanks for this. so do i just paste in the same vba and change beforeClose to beforeSave or do i change it before pasting it in? I tried doign this but it didnt seem to like it very much M

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...

Hi my name is Marc, Business Analyst @ BBC in London. used excel for a number of years but looking to expand my knowledge and skills in this area. Cheers Marc