mentioned

  1. R

    Require formula

    Hello, I have data as mentioned below in each row. ,,,,,,,,,,,,,,,,AM,,,,,,,,,,,FE,,,,,,,BA ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,DD,,,,,, HQ,,,,,,,BB,,,,,,,,,,,,,,,,,,,,,,,DF The output that I require is as mentioned below. AM,FE,BA DD HQ,BB,DF Regards, Vikas
  2. V

    Mail from excel

    Hi, I am building a code where mails will be send automatically from excel according to felds. Like email ids will get seleced from cell B2, CC from C2 and so on.. i have finished some part of it the only issue is that i want snapshot of the table mentioned in another tab (Table). We can...
  3. G

    VBA for Outlook meeting room booking

    Hi All, I have an excel workbook with the list of meeting rooms mentioned in column A of Sheet1. For example, I have "Room1" mentioned in cell A1 in sheet1. If I select, a time ,let's say 1pm to 2pm, in cell B1, a new link or button should appear in C1. When I click this new button in C1, it...
  4. A

    locking cells below a particular row after above mentioned date

    Hi I am working in a small manufacturing unit and not well acquainted in Excel. It would be of great help to me if this forum could solve the problem mentioned below Each column from its 6th row has to be locked after the date mentioned in 4th row and time mentioned in 5th row expires with...
  5. J

    VBA copy sheet

    In a workbook, which workbookname and sheet will change, but I want to copy into this workbook/sheet I am in when running the macro. The code for what I want to copy is already written: Developed a code: workbooks.open Filename:="S:\Report.xlsx. Sheets("Januay").select...
  6. R

    Finding Words with in Excel

    I have a sheet with a list of name example Aaron Tumbler, chris Turner etc Have got another sheet in which the names are mentioned as Tumbler Aaron, Turner Chris... Need help to check whether name mentioned in sheet 2 is there in sheet 1 Thanks for your help
  7. N

    Calculate Rate based on latest Date

    Hi All, I have below columns :- 1) Posting Date(Column I) 2) Total quantity(Column U) 3) Value in Obj. Crcy(Column V) 4) ESIGNAM(Column AG) Now in column AK I want to below mentioned logic :- For example A is repeated 3 time with 3(1-jan, 2-jan,3-jan) different posting dates, then I have...
  8. N

    vba to navigate a webpage mentioned in worksheet cell.

    Hi Friends I have created a macro. If I run this macro I visit a URL which is mentioned in my vba code. I want to change this url every time. so is there a way that I enter the URL in excel cell A2 (Sheet1) and vba pick the url from this cell instead of mentioning the url in vba. Please help me...
  9. apgmin

    Age eligibility

    In cell M2 is mentioned the date of birth of the student. In cell Q2 is mentioned the course he or she is applying for ( It is a drop down list consisting of "MBA" and 3 other entries, IMBA, BBA, BHA ) In cell Y15 is mentioned todays date ( volatile ) Now If Q2 is selected as MBA then the age...
  10. N

    Power Query Lookup range changed based on Cell value

    Hi All, I have a Master sheet having wk number mentioned in first column. I want to apply vlookup on name based on value mentioned in Wk number column. For example :- if wk number is less than 26 than vlookup apply from Group 1 sheet and pick the "Current Hrs" value based on Resource Name...
  11. M

    Sumproduct formula Error

    Hi, Please find here below the link of sample workbook. Where i am trying to fetch the data with the help of Sumproduct formula but it is giving the correct output. I have mentioned the Expected results in Slip tab. Any help would highly be appreciated. Thank you in advance. Regards...
  12. B

    Can we fix shape position with Cell Value?

    iam giving input in A1 TO A10 In sheet 1 at sheet 2 shapes should appear with specific position as mentioned in sheet 1(A1:A10) Can i get help with this? Sub populatearrow() Dim shapi As Shape Set shapi = Sheets("Sheet 2").Shapes("Rectangle 2") Dim shap As Shape Dim x Dim position position...
  13. G

    Pull data from one sheet to another sheet

    Dear All, Please find below mentioned VBA code.I tried to take printout of the employees name in certificate.Name are mentioned in workers sheet and certificate format is in Worker_Certificate sheet. Private Sub CommandButton1_Click() x = 2 Sheets("Workers").Range("B" & x).Copy...
  14. N

    Copy Data to multiple Worksheet Based on cell values

    Hi All, I have an workbook. and below sheets contains :- 1) RAMSES : this is main sheet from where I need to copy only column F and paste in multiple sheets. based on cell value mentioned in column C. 2) CTA : data needs to paste in this sheet if any cell value of column C in Ramses is...
  15. R

    VLOOKUP and SUM based on an autofiltered list

    Hi! I'm having trouble finding a solution to the mentioned problem. Maybe someone can help me! In one sheet, I have a table where cells D5 to D100 have a series of repeated categories and a bunch of other columns that have additional information but not related to my problem. Then, in another...
  16. J

    Referring to a named range within a formula

    Hi, I'm using the following formula which works fine. "_1" is the name of the array being referenced, and is also typed as a value in cell C4. =INDEX(_1,MATCH($A7,'1'!$A:$A,0),MATCH($C$3,'1'!$6:$6,0)) As I mentioned the array name "_1" is hard keyed into cell C4. The following, almost...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top