Search results

Hello Sorry for the delay been busy with work. Couldn't get this to work i have copied the code in to a module in the VBA personal workbook but not sure how to get it to work?! Any tips for a complete VBA idiot? Martin

Thanks I'll give it a go and let you know how I get on.

Hello When you double click on a figure on a pivot table and it opens the details on a separate tab, how do you get that page to auto fit the data? I have to send the table out to staff who aren't very Excel savvy and asking them the select the sheet and expand the columns and row to fit the...

yep. the mac version work differently. thanks for the replies. apologies for not spotting my error sooner. skinpup

mmm :-( on mac one that doesn't seem to happen

mmm no don't see the little ? i'm working on excel for mac 2011 will this make a difference? sorry should have mentioned this earlier. skinpup

hello i've seen excel sheets where there is a filter button 'built in' to the header row as a little icon rather that the standard big down button. how do you do that? i'm using excel for mac 2011 and excel 2010

thanks faseeh =CONCATENATE(E3,CHAR(10),G3,CHAR(10),I3,CHAR(10),K3) gets the text from each cell in to one, what i can't workout is getting it to form a list with the text from each cell on a new line inside the one cell? i've made sure the cell is wrapping text and tried resizing the cell...

hello kaushik here is a sample of the sheet with comments alongside the cells concerned https://hotfile.com/dl/173279571/5481959/arrange_vertical.xlsx.html i'm sure i'm missing something very obvious :-) skinpup

hello i get the data to collect in the one cell. what i need it to do is arrange the different comments from each cell one above the other e.g. first cell might have a comment this long second cell might be short third cell might be blank fourth cell my be very very very very very very long...

cheers kaushik thanks for the tips on getting started and the speedy reply. yeah that file you sent looks like what i need i'll play around with it and see if i get it to work, like i said in post as soon as i see vba i start to worry :-) but that one looks simple enough. i'll let you know...

Hello Had a look around web for answer to this and they all seem to rapidly become discussions about vba and long strings of formulas I don't understand, still very new to excel, but this site has been a great help. I have a table used to record audit checks and across the table for each...