fetch

hello everyone, i have a big sheet and data fetch from other workbook via vlookuop where i have blank cell in base sheet, results are 01/0/1900. i need to fetch month details but bcoz of this it;s showing january which is incorrect. kindly help me to get the month result "0" or blank if we...

I am new in VBA macro , so can someone help me to fetch report from outlook (by subject-line only). Today.

Hi , Shall some one help to to fetch the report from outlook in excel condition is below 1) Check all today's mail from inbox and check in sent box whether we replied or not. 2) In report get all mail by sub line mark red to all not replied mail OR in next column print "yes" if replied "No"...

Hello Gurus, Need your help with the following: Table 1: Has the following values <tbody> Date Employee Value Numbering 2019-05-15 12345 10 Fill this row 2019-01-04 11111 1 Fill this row </tbody> Table 2: has the following values with a start date and end date as a range and...

Hi Experts and all, I have new and very 1st query on access db. Table name "Data", contains 4th and 5th column email id's. I want to fetch that in variable. Can any one provide me select query, how to write that.. Many Thanks..

I am using the following two formula, =INDEX($L$2:$L$3583,MATCH(1,($AA$1=$R$2:$R$3583)*(AB2=$M$2:$M$3583),0)) Or =SUMIF($L$2:$L$3583,INDEX(L:L,MATCH(1,(M:M=AB3)*(R:R=$AA$1),0))) They both are array formula. The problem is that they only fetch the first value matched, and I want to add all the...

I have 5 different files where my team make entries. I have one master which fetch data from those multiple files. Once data fetch is done. I want fetch data should delete from those 5 different files. So that when next time i fetch data it should not include data which is already in master.

Dear Experts, Greetings from India. Is it possible that we can fetch values from comma separated values from a single cell to their corresponding values from a range? Col A Col B Col C Col D A AF A, B, D, E AF, AD, CMD, CW B AD C...

Hi, I would like to fetch data from an Internet page to Excel, but the problem is that the web page in question does not have a table that is importable. Is it still possible to fetch the data, or is there no hope? I'd like to fetch information from a website called Avanza. E.g. this stock...

Hi there In the Excel table from the attachment, starting from column EQ, I would like to have the VBA filldown the formula in row 6 of each column for the respective column. This is what I have so far: Sub EnableFormulas() Dim Lastrow As Long Application.ScreenUpdating = False Lastrow =...

Hi everyone, I currently have a stock list with various information for each stock (8 columns) being retrieved using WebService(). The problem is that my stock list contains 2000 stocks. This often takes a very long time in excel. I am wondering whether there is a VBA method of speeding this...

hi, I have huge data in 2 Excel workbooks, i have to fetch data from workbook1 to workbook2. Both files are on shared drive. i tried to use vlookup to fetch data from Worbook1 to Workbook2 but due to having huge data(round about 5000 raws, 50 to 60 columns ), Vlookup does not get refresh...

Hi, I need to be able to past Part_Nos into a column in excel and Excel should be able fetch the corresponding description and cost price in the next columns which is available on a SQL data base. The number of Part_No can vary from 5 to 200. Appreciate if you could help me to achieve this. I...