I have VBA code in excel which extract information from MS word document. after successful extraction i see small rectangular box at the end of extraction and it will delete automatically when i double clink on cell.
need help please to identify the issue and fix.
I have sheet attached.
i am trying to find out median value of power hours (B Col) for same part numbers (A col) and put it in C column. I am able to Averageif forumla to arrive avg of 350,450,550 but cannot do median if. need formula to fill median value in c3 and c6 cell . i have attached...
I have sheet attached here, need output as per Column F.
The formula in Cell F should find specific text in B, C, D, E cells to get the output.
Conditions
if it finds all cells have "Fully Delivered" the overall status should be "Fully Delivered"
If it finds all cells have "Fully Delivered" and...
Thanks for the reply Pascal
Original search workbook have multiple sheets , i need code to search only in sheet named " All Levels".
I tried with "Set rFound = wks.UsedRange.Find(strSearch)" which will search in all sheets and all cells. i got same result.
In F8 step by step run it works...
I have code which copy data from .XLS sheets from selected folder and paste in Active sheet.
Problem: when i run code its copying same data twice. See and run macro.
Please help.
Attachment:
Code avbl in this sheet. and also sample test sheet.
Please help
I have table where A column list Date and B Price.
I am trying to read top 5 least prices using =Small function, Same time i am looking for Date of corresponding small value using =Index & Match.
Prob: when the 2 least same price falls in top 5, i am able to get date of only first but not the...
Nishu
are you looking for value where row and column data matches with search criteria.
in your sheet attached its not very clear about the need. please elaborate Que to help fast.
Mr Singh
I have created sheet based on posted query using VB code. You can see the button in Sheet1 , when you press it will ask how many sheets you want to create, based on input those many will be created. Hope this suit and help your requirement. let forum know otherwise
Please see attached...
I have Engineer Skill table. In Col A i have engineers Name and in Row 2 i have skills required.
For each engineer there is Required skill level and Actual Skill level rating given , from 1 to 5.
Help:
If Required skill is greater than Actual skill, then actual cell should highlight. this helps...
when i run the macro i got output something like this (still showed some warning). can you manually show output format which you are looking. also check the spreadsheet attached.
i think i misunderstood the Page distribution in first place, apologies.
i may not be able to help with VB scripting, i think i have to pass this for other experts.
if range in sheet 2 changes, formula still works. All you need to change is range in Name manager. Else make sheet 2 names range as table, so it will automatically consider the range whenever you can add new name