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="" xsi:noNameSpaceSchemaLocation="TCS_Players.xsd" version="">...
  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

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...