LOL sorry misunderstood the first time ... understand now ....
have adjusted to incoprate a third option .... so you can use just the first option on its own / first option with second and third option /first option with second / first option with third ..... if not using second do like...
Ok after going through the code this is how i changed it .... might be suitable to what you need ....
it works for a range of cells in a column using just the first option in the function and not using the optional part eg used like =concat(a1:a10)
if a4 is FALSE its not concated into the string...
Here you go tried this works for me ........
Paste this into a empty macro .. and then connect to your check box
it will hide and unhide your column
Sub CB()
If Sheets("Client fwd plan").Columns("B").EntireColumn.Hidden = True Then
Sheets("Client fwd plan").Columns("B").EntireColumn.Hidden =...
For highlighting middle name you can also try this as over here some people have more than one middle name lol ..... and this will work for multiple middle names or just one middle name ... again like Somendra Misra solution paste into the conditional formatting section and then choose you...
Ok try this out on supplied sheet .... it checks each sheet for the required column name and adds the data in the cells to the master sheet in their colum
test it on my supplied sheet as i had to guess your set up ... eg master sheet is sheet one .... then next 7 sheets are the data (know you...
Hi just finished this and noticed you dont seem to have sorted it out yet ...
Have tested it and it clears all the rows out on all the sheets from 7 on that are blank .... anyway try it out on a sample book like the one you uploaded and see if its suitable
Sub clearrows()
Dim CheckCell As...
Hi just looking at this again as i wasnt able to figure out a answer earlier so delighted to see NARAYANK991 answer... so downloaded sheet again and added NARAYANK991 formula ... which worked .... but noticed a little error .... if you add 1 to cells to cells F6 to F9 it dose not give a answer...
Lol forgot to add file ........ also added another macro which adds 10 rows so if you get fed up adding single rows this will add ten or if you change the value below as many as you think you will need
Sub addingRows()
'
' addingRows Macro
'
Dim i As Integer
count_r = Sheet1.Cells(Rows.Count...
Ok wrote a macro hopefully covers your needs ... discovered the little problem above was a autofill feature of excell which caused problems , as it kept adding the sum formula to the blank row required in this macro ... so i added a line to disable it when running the macro ... i also added the...
Ok able to do that but have run into a little problem so wont get a chance till tomorrow evening to finish it .... either my version of excel is playing up or i discovered a strange occurance in excel which i posted a new thread on to see if it happens to anyone else ... and is messing up the...
Ok was doing a macro for someone who posted in this forum .... when the following occurance effects how it works
and was wondering dose it happen with other peoples excel or just mine
have a simple formula in column C ... =B1+A1
which i then drag down for say 10 rows .... now i fill row A with...
not quite sure what you mean ...... think what you mean is ... for example cell1 row A is a total from say column D ... cell 2 row A is a total from colum E etc
then could you just pull from those colums into row C rather than put them in Column A first ..... if thats it .... yes you should be...
Ok try this .... only thing you need to do is always leave a blank cell before totals ..... when you run out of space just insert more rows if needed.
Sub move_cells()
'finds first blank row in Column A
num_rows = Sheet1.Range("a1").End(xlDown).Row
'finds the number of rows to the blank before...
This might point you in the right direction .... first off it works it gets the info from one cloumn and puts it in another ..... if you then add to it and run again it adds to the other column ..... i added a total in second column and it sums up the info .... if you add more data to first...
Ok .... had to see max char count i could get to using the choose function .... so got it dynamic up to 35 characters ..... which needed a formula of length 7,867 ... max allowed by excel is 8,192 ....
Nice I like this thread so thought id see how i would do it ... if i had to do it and hadnt access to VBA code i could depending on how many characters you can use in a formula make it dynamic up to string length of 255 but not going to try as it would be a massive formula and not sure that size...
Nice havent used ...MMULT ... function yet ... havent even looked up to find out how it works ... have seen it in a formula but was a very complex formula so left it till im better at breaking down complex formulas.
this though was nice as it was easy to see what it was doing so i was able to...
Here is one way of getting that result but its not the only way and im sure someone can give you a better way but while youre waiting on a another response it will work and keep you going
Both your formulas work .... i believe though you are not getting the results you expected though. and i cant explain why as its very complicated ... im sure some of the ninjas can but if you look at the spread sheet you can see it suming up the 5 and 17 that connect .... but your other formula...
sorry for the confusion ... i will explain my example (but it is seperate from what Narayank991 is doing for you so no need to get my suggestion confused with the macro he is doing for you)
Basically sheet 1 is how i vision your present situation eg column A (sheet 1)are 36 employees and there...
Hi Narayan first on your explanation of the formula usage above ... i get a little mixed up at times when im working out formulas especially when i also trying to visualize the overall problem lol i had ment to use the match(B2,$B$2:$B$37 which i used on sheet 2
Sorry about uploading the file...
Hope you dont mind my input ... just looked at this as it seemed like a very interesting problem ... above what i could do anyway ... but i was haveing a look to see how messy and tricky it way ... have spotted one thing that might help ... not in your vba code but the overall problem.
attached...
Nice spot Somendra ... no => dosent work for me lol .... had formula posted and then i relailsed he needed = in it ... so edited and added = not realising it would give error in that spot .... re edited it to fix that