india

  1. K

    Create a low/high range of postal codes

    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...
  2. M

    VBA Match Cell Range to Worksheet Name and copy/paste & create pdf

    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...
  3. S

    Map is not exportable because it contains the following: Denormalized data

    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">...
  4. D

    Multiple DB Query in same workbook.

    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...
  5. M

    count cell in column for last 5 days with diffrent conditions

    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 &...
  6. M

    How to Replace blank cell with specific value

    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...
  7. C

    Insert html in cell for import to website

    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...
  8. S

    How to Freeze Share holdings (Quantity) as per debit balance

    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...
  9. M

    Searchable Drop down list - Data Validation - For entire coloumn**

    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...
  10. N

    Study Group in India

    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...
  11. T

    Apply filter on the basis of multiple values

    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...
  12. P

    Restrict Copy

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

    Excel crashes when opening file

    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...
  14. B

    How to learn MS Access

    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.
  15. I

    search and merge data from two sheets

    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...
  16. M

    Register: ModelOff APAC Meetups 2015 (AUS, IND, HK, SG)

    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...
  17. A

    Podcast Subscription Not available Outside US

    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

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top