Search results

Hi All, I am new to Power BI, Can anybody suggest me how to create data model for my specific scenario. I have below mentioned tables :- 1) Resource Plan : it contains details for all resources daily how much hours they have to fill domain wise. 2) Timesheet : it contains the data for all...

Hi All, I have a Master Table Worksheet. I want to print message in Column DX "to be check" if below mentioned conditions matches. 1) RESOURCE STATUS = Should be ENGAGED/APPROVED. 2) ASSIGNMENT STATUS = Should be Blank 3) Now check for month from cell CW to R any value written as zero but the...

Hi All, I have 1 master sheet in which I need to apply vlookup function in multiple sheets and from 3 different files(All files are located in same folder). Below are the headings for which I am applying vlookup function :- 3G 'TRANS_TYPEIP to IP Swap StatusIntervention DateIP to IP commentIP...

Hi All, I have raw data in below format around 20K to 30K rows and I need to rearrange the rows based on below mentioned condition :- 1) I need to filter on Ring name for example I filter Ring A05. 2) Then I filter 1 by 1 to ATN loop back column for example : I filter 10.35.201.1. 3)...

Hi All, I have worksheet where I have a below 2 main sheets :- 1) Code list : having example list of 1 codes which is required to copy for all the different IP's 2) IP list : for different criteria. currently I am taking example of 2 example :- 1) MW : First I go to code list and there in...

Hi All, I have found the below mentioned code by google to copy the files from a particular location to another :- But its showing error while I am changing the Frompath: to "https://abc.internal.abc.com/sites/Documents/N4S>" that path does not exists. Also when I am running same code in local...

Hi All, I have to return value in comma seperated(or "-" sign) in sheet 1 from range D3 :E last row. Criteria mentioned in G1 and I1. Example : In sheet 1 Header name 3G , and cell B3 which is 30537C1 in current case I will go to "All data" sheet column G and filter with same code :30537C1 and...

Hi All, I have data sheet where I have following columns starting from Cell A1 to P1 Work Order_WO000 Dummy Project (PC)WO000 Type_WO000 Dummy LLC Upload DateUS000 Node 2GWO600 2G Line Swap/LL Avoided StatusWO600 2G Line Swap/LL Avoided ActualWO600 2G Line Swap/LL Avoided Upload DateUS000 Node...

Hi All, I have 2 sheets :- 1) Sheet name "Final Sheet" : Raw data which is coming after running some calculation after a vba macro.(currently not attached other sheets). raw dump will always changes as soon as I will run macro a macro. 2) Sheet 2 name "Pivot" : this sheet contains the pivot...

Hi All, I learned a lot from this site and I applied many things useful tracker in my current work roll which is very much appreciated by my superiors. I am Thankful to all of you. Now I want to share I issue about excel. I always see the syntax wherever I am applying any formula. yesterday...

Hi All, I have two sheet in a workbook, 1 sheet named Summary & 2nd Data In Summary sheet I am taking input from User for country name selection , No of resourses, & KT duration(In weeks) in cells D6,G6 & J6 respectively. Now in data sheet cell contains the following values: K26 : Total...

Hi All, I am preparing a Budget Forecasting tracker in which I have to capture all the traveling details of 20 countries(which contains expenses like Ticket cost , Visa cost , Accommodation etc.......) I want to know if it is possible to link excel with any site from where we can link excel...

Hi All, I have an excel file in shared location. Now issue I am facing now is that every time my team mates complaining that they are updating that tracker but after 1-2 days the changes they made there are not available in it. For that I use Track changes option to cross check why/who is...

Hi All, Can anybody suggest me the formula to extract the name of person according to current week number. my data range is from A3:BB7 Name Total Issues 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50...

Hi All, First of all I am very thankful to all of the members of this site. I learned a lot from this site and applying the same in daily routine work and appriciated by all of my team mates and Managers. Thank you all. Now I am learning about macros. Few days back I saw 1 of post about...

Hi All, From last 2-3 days a below message box showing while I am saving excel file. Can anybody suggest why this message box showing and how to remove it ? "Privacy warning : This document contains macro, Active X control, xml expansion pack information , or web component ,this may include...

Hi All, I have a excel file in .xlsb format located in our shared drive. and out of 10 times its corrupt almost 5 times while saving. Can anybody suggest any reasons why file corrupt so frequently ? Thanks in advance. Regards, Rajender

Hi All, Can anybody suggest if we can create a macro to create a log file with user name detail along with date and time as soon as any user save the document ? Thanks in advance. Regards, Rajender

Hi All, I am new to VBA . On basis of recording and online search I created a macro but it sometimes working and sometime not. Can anybody suggest me where is the error ? I have a sheets with name 1) Issues_Tracking sheet : - All the raw data(range from A5:P65000) 2) Filter Sheet :-...

Hi All, I have an excel sheet in which I have to extract the count with having multiple conditions as follows :- 1) Main data sheet is : CD_MW_Training Plan & summery needs in sheet : Snap Shot1 2) In cell D5 & E5 I need the the sum of hours meeting creteria mentioned in D4,E4,A5...

Hi All, Please find the link for the same. https://skydrive.live.com/#cid=393CD98CEE2A349F&id=393CD98CEE2A349F!105 I need to get the name of trainings(showing in sheet "Certification Month Wise" from range H3:T4. the result I need to get in sheet name "Final Sheet". The unique value by...