This is Another issue. Here I want formula.Pls see sheet.
This is Another issue. Here I want formula.Pls see sheet.
9_Oct_18 and Sep_18 don't have "Sales" or "EBIDTA" columns
Rest is (I think) what you were asking for
2018 button is working, I did not do the others but the process is the same
No other sheetThis is Another issue. Here I want formula. Pls see sheet.
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Dear Paul Sir
Mind Freaking !!! Awesome!!!
Perfect, You are done it………
I am really thankful for its wonderful Code in one shot.
Note: how to direct jump on that year after click button. Now highlighted column is perfectly but I move every time here & there to see highlighted column.
Regards
Amar
Dear Sir
This is last help required then I am successful in my fully work.
above Same sheet I will extract data in separate sheet year wise stocks extract with formula.All detailed in sheet.Pls see sheet.
Regards
Amar
In col C
This seems to work and you can integrate the formula into your main spreadsheet=IF(ISERROR(FIND($B$1,$A8)),"NO","YES")
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Dear Paul Sir
Finally done my work by your great Help.Awesome and unbelievable, it was more than expected.
.
Thank you so much, your assistance is greatly appreciated
Regards
Amar