mentioned

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

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...

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...

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...

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...

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

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...