Kindly if anyone can help me with Excel Report in terms on weekly comparison Chart report by counting the dates with exist in F column 31-mar-2014
if we click Monday so it should show 2 weeks comparison chart of Monday and should have multiple option as well of clicking week days!.
with dynamic...
I here any possibility that can we Make it Excel dynamic range cause the excel varies its range? if the code would be really big so it would take load of time and memory as well
Sub macro_22333()
Dim excelApp As Object
Dim z As Integer
Set excelApp = GetObject(, "Excel.Application")
Set...
We basically Place customer data in excel and then we update that data shipment one by one in the system..so is there any possibility of doing it with Macro? cause in the Software there is an Macro Option !!
like showing the path to the software from were to get the data and how and were to...
need help in creating a impressive chart so that i can impress my boss ;)...
https://docs.google.com/spreadsheet/ccc?key=0Ah3qQ3ZqPOsPdC1jaTYxNGxtRGpDTHdhUy1fOC1Ubnc
here the link to the Data
I have one workbook (Excel 2007) with 2 sheets. Sheet-1 contains 4 columns like the following:
Excel Sheet 1
COLUMN 1 COLUMN 2 COLUMN 3 COLUMN 4
1005 10 Sam Royal Blue
1005 20 Peter Navy Blue
1006 50 Mary Rose
1100 40 Sonam Green
1156 80 Rashmi Pink
And the Sheet -2 also contains 4...
This formula check data in C1,D1 in A:A & B:B could it be extended to check of
D1,E1 & F1 in A:A, B:B & C:C ?
formula is
=IF(C2="", "", IF(D2=INDEX(B$2:B$65536, MATCH(C2,A$2:A$65536, 0)), "", "mismatch"))
this is the array formula am using to find the last date
=INDEX(Date,SUMPRODUCT(MAX((item=$A4)*ROW(item)))-ROW(Date)+1)
how can i find the 2nd last date!
i have a database on a large scale
B COLUMN L COLUMN P COLUMN R COLUMN S column Tcolumn
PRODUCT CODE Date HR METER CATEGORY HR meter/differnce No. of Days
APJH-1234 15/2/11 2345 COM
there are to categories Com and Usm
there are 800...
I would Like to 1st Thank Chandoo for providing a Paramount platform for excel help....and HUI for all the help based on my ITV project the Designing, Flow charts and all the effort and LUKE for the formulas, MACO's and concepts.....All i really would like to says the vast knowledge and skill...
WHEN WE MOVE THE MOUSE COERCER ON THE CHAT FLOOR SO IT SHOWS THE COMMENT BOX FLOOR
SO HOW TO HIDE THAT COMMENT BOX !! OR DI ACTIVE THE COMMENT OPTION IN EXCEL 2003
THE FORMULA IS =VLOOKUP(B2,'[FINAL-Main ITV REPORT-PART1.xls]Database'!$B$2:$I$851,2,FALSE)
AND I NEED TO ADD IF(ISNA AND I AM NOT ABLE TO DO IT KINDLY HELP ME OUT PPL!!
Need to modify the macro from deleting duplicates based on 2 criteria 1st the duplicate and 2nd criteria dd/mm/yy
for e.g
Columns
A serial B Names B C quantity D Quality E Category ....G DATE..etc etc....
Should search for duplicates in Column B & for Dates In G
If found
1 Grapes 12...
i am generating #ref error the transfer of data in the required sheet is perfect
The automatically generated sheet from main sheet...formula as :
in A2 : =IF(Database!I2="usm",MAX(A$1:A1)+1,"")
in B2 : =IF(ROW()>MAX($A:$A)+1,"",OFFSET(Database!$A$1,MATCH(ROW()-1,$A:$A,0)-1,COLUMN()-2))...
Column A is Hidden and i need to Modify it When i delete rows and add new information based rows... so due to which i have to unhide the Row A in all sheets and AutoFill them and again Hide the Column A....
Sub autofill()
Sheets(Array("USM Enroute", "MNR Avaliable", "COMMERCIAL", "DMG"...
I need help for creating a Impressive Dynamic Chart Report Like Chandoo's
http://chandoo.org/wp/2010/08/31/dynamic-chart-with-check-boxes/ << like this one
and i am using excel 2003
daily Has two options And Monthly as well Com and NonCom and each Of these two and Additional 2 options...
=IF(Database!B2="", "", IF(Database!B2=INDEX(INVENTORY!B:B, MATCH(B2,INVENTORY!B:B, 0)), "", "mismatch"))
this formula is showing subjected Error...rather then showing Mismatch is the cell value is not found...
kind improve the formula for me id be really glad....
Can any one Kindly Plssss...Modify this Coding To The Selected Data From 1 WorkBook's Sheet1 To Another Already Created WorkBook's Sheet1 in My documents.
Will Appreciate the HELP
Sub CopySelectedMulti()
Dim NextRow&, rng As Range
With Sheets("Sheet2")
For Each rng In Selection.Areas
On...