Hi vletm,
i use the sample file to extract data from Database. the excel file is the input file and it will extract data from multiple table in Microsoft database.
Hi Vletm,
Where do You get 'Data type mismatch'? - after running database.
in the below screenshot you can se D2 cell is saved as text with ' but on the format cells window its in "General" format, C2 cell returns true for formula =istext(D2).
select Error Checkin Options...
and do wanted...
Hi,
In the attached file i have 2 column with reference 1 and reference 2 which should be in Text format and used to extract data from Microsoft office database.
issue is i have to copy data from multiple excel files(Various version xls, xlsx and macro enabled) and save in excel 97-2003...
Hi All,
Can you help with the attached macro.
Trying to move data based on column C to the respective sheet. i have tried below code but its not working.
need to move data for 10+ sheets
Hi,
Can you help with Macro for the Attached Spread sheet.
For Sheet Trans1 and Trans 2 on Column S i have IF condition for 7 different cells and values
which returns results after checking all the 7 conditions
with Sheet Main i need the results of Trans1 and Trans2 against Gnum i have used...
Hi Team,
i have need to compare two sheet and identify the new item and deleted item using the below formula on column C on respective Sheets
Can you help me with the macro with the Formula and Copy the line Respective Sheets.
Sheet 1 - Rows with Value "New Item" to New item Sheet
Sheet 2 -...
Hi All,
i got the desired results if the range contains data, however incase of empty cell its not giving me the results. Can you help on the below.
Products
Size 1
Size 2
Size 3
Size 4
Size 5
Results
AAA
1
3
5
Not in Sequence
BBB
15
22
45
54
60
In Sequence
CCC
10
8
45
Not in...
Hi,
Can you help me with formula for the below table.
I have multiple user with 5 different sizes, I need to check if the sizes are higher for the next sizes in sequence if its higher it should give me result as “In Sequence” or “Not In sequence”.
Products
Size 1
Size 2
Size 3
Size 4
Size 5...
Hi
Need help on extraction adjacent value of matching lookup value.
In attached spreadsheet table A1:H13 contains data and not properly formatted has details
On the same spread sheet I need to extract details for column m1 to m8 with value of next cell value from the table A1:H13
Hi All,
Can you help with formula with the attached report?
I have raw data with primary number, secondary number and shop, I need to convert the raw data input into output available on sheet 2.
Thanks
Mohan
I use the MM/DD/YYYY format, all the dates is copied for Power bi table, tried changing the date format but not able to have same format for all the dates in B column
Hi All,
Requesting help convert the Column B date format (Wrong conversion of date) to column F.
Tried changing date format highlight in yellow (Column J to M) using formulas, but still getting wrong conversion required your suggestion for date conversion
As data will be last 3 months, I use 2019M+Month (05) to create helper column manually
instead we use last digit on column B in output file to match and extract value from input file. I have modified the formula on column F in the output file
Here attached the raw file with no helper column A and B.
regarding the multiple year, the extract will be for last 3 months and it will be having multiple years
Hi Marc,
so Input2 workbook does not need any helper column (if ok Input2 columns A & B - at least B - could be deleted) --> added helper column for input2 as I get raw data which will start from column C to G,
for second point its ok, to be deleted.
Can you help me with...
Hi All,
Can you help me with combined report with two input file.
Wanted to create macro to extract input file 1 and input file 2 to have one combined report comparing value against each store
Input 1 – We have 5 column
Input 2 – We need to add 2 helper column to have the same format month as...