india

Hi, I have a list of postal codes arranged on 1 column of around 13000 rows. Some of these postal codes could be collapsed and setup in ranges since they are consecutive like in the example below: 121012 and 121013 could be collapsed in 1 row as Low:121012 High:121013 <tbody> Country IATA...

I'm trying to write a macro that matches an F Column cell in the with the sheet name and then pulls data from Active sheet and then copies to the exact sheet Name where I want to insert the cell value & create pdf based on the sheet SHEETNAMEs mentioned below SamplePDF1 PDFfile2 Excel3 PDF4 When...

I have created a following Schema in Dreamweaver to import multiple player name in cricket scoring software. <?xml version="1.0" encoding="ISO-8859-1"?> <CricketModel xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNameSpaceSchemaLocation="TCS_Players.xsd" version="11.0.11.00">...

Hi All, I have 3 Oracle DB's (India, China, Japan) I have written a macro which connects to DB & extracts records. But I have to run each macro 3 times by changing the DB name. Is there any way where macro automatically connects to 3 DB's and extract India records to Sheet1, China records to...

I want program for the below condition.(Last 5 Days Count City wise .) ....( eg .Today is -19th July) 1) Filter to Column "A" Status For Working . 2) Filter to Column "B" City For Pune. 3) Get Till date (Today) Count of column "A" in the cell of table ( Today 19th) 4) Filter Today()-1 &...

I want program for below condition 1. filter to column "D" for blank . 2. Replace all blank cell in column "D" with Not OK. 3. Clear Filter . 4. filter to column "D" for Not OK. 5. filter to column "A" for Pending. 6. Replace all these pending As Pending - Not OK Example is Row Data <style...

I have a program (app) that imports my product data to the store. Within the product description, they can only import what the spreadsheet allows. So for rugs as example, I will see (tuft loops, India, wool, etc.). What I want to see is (Type Construction: Tuft Loops, Made in: India...

Hi It would be grateful if anyone can tell how to calculate QUANTITY to be freeze depend on the Debit Amt. How can we automate in Excel for repeat client code basis as shown in sample column for Freeze Qty & Freeze Value (should be as per debit amount). If holding value is more than Debit amount...

I have varied requirement Requirement 1: I have an excel with column A and Column right now with normal Data Validation drop down list Ex: Column A contains drop down variables like India, China, Japan, US, Indonesia Column B contains drop down variables like places of respective...

Dear participants from India, Greetings to you and hope you had a great 69th Republic Day celebration yesterday! As we all know, clearing different levels of ModelOff is very challenging and winning the competition is a Herculean task, at the very least! (All thanks to the wonderful team...

I have this data . <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Country Name India A India B India C Australia D Australia E Peru F Peru G Chile H Chile I </tbody> Now I want to apply...

Dear Friends How can I stop a user from using the copy feature in a particular workbook. Regards Pigeon INDIA

Hello, I am very confused. My macro was working perfectly opening files and consolidating and now it crashes every time I try to run it on the first line of code. Sub PerformAll() Dim wbSource As Workbook Dim wbDestination As Workbook Dim wbSource2 As Workbook Dim wbDestination2 As Workbook...

Hi, I am new to MS Access. I know nothing about MS Access. However I want to learn it. I have basic knowledge about (excel) VBA. Thinking about joining weekend classes for the same. Could you please advise me how should I proceed. Location - India.

Hi,　 I have difference info from Sheet1 & Sheet2 and I need to combine them into Sheet3. <tbody> sheet1 sheet2 Item Reading Item Name A 10 A China A 70 A Hong Kong A 51 A Taiwan A 45 A Australia B 12 B Korea B 11 B USA B 48 B Japan C 142 C Iceland C 21 C...

This May and June, the ModelOff Team is traveling around APAC to hold local networking events - and you are invited to join the celebrations! Six FREE drinks networking events will be held in Melbourne (May 26), Sydney (May 27), Singapore (June 9), Bangalore (June 10), Hong Kong (June 11) and...

Was not able to subscribe to your podacst from India. Please make the same available as it will be helpful for many of us here Abhilash