I wanted to do an automatic reconciliation via excel. It is simply that i want to compare two columns with each other and extract non-matching entries within them. Meaning that for each record in one column, only one record in another column must match. An example will more clarify this case:

This is the result i want, for each record in column B only one record in column A must match and extracting only the non-matching entries in column 3 & 4 as per the below result:

Hello,

Grateful if you guide me to solve the following problem:
I'm trying to automatically copy data from a range of cells from a desktop Excel file to an Excel table embedded on a website, by pressing a button on the desktop excel file. The embedded table is hosted on MS Skydrive. Then, during the same session, I want the calculated data from a range of cells of the web embedded table to be copied on the desktop Excel file. The web embedded table can not be downloaded, nor can it be fully opened, but it can be directly edited on the website.

I have come across a thought, that if there is a way to do an automatic reconciliation via excel. It is simply that i want to compare two columns with each other and extract non-matching entries within them. Meaning that for each record in one column, only one record in another column must match. An example will more clarify this case:

Hi there,

The situation:

I have a list of people with characteristics (Name, Age, Address...) that I'm creating on excel. I want to be able to select a cell, click a button and:

Hi all ,

I dont want to run this particular script, if the system date crossed 24/12/2012.

Any suggestions, what date function should i add in this script which will check the date = 24/12/2012 and will exit the script.
...................................................
Set wshShell = wscript.CreateObject("WScript.Shell")

msgbox("Hello")
....................................................

Please note this is a notepad made .vbe file script.

Thanks
Ruth

Hi

I have 2 cells A1 & B1 .both contain text

I want it to apply the rule if the exact text of B1 is contained somewhere within the text of A1

eg A1: "forum.abcnanmeter" B1: "nanmeter"

it would apply rule as the exact text of B1 is contained within A1

Thanks in adavnce

I have a spreadsheet with a range of numbers with corresponding percentages. Lookup needs to check the range and return the correct percentage. Tried LOOKUP, INDEX/MATCH and more and still cant get the results I need.

Qty in ea or UOM Discount %
275-400 0.50%
401-600 1.00%
601-1000 1.50%
1001-1500 2.00%
1501-1800 2.25%
1801-2000 3.00%
2000-3500 3.75%
3501-5000 4.00%
5001-7500 5.00%
7501+ 6.00%

THIS CODE WORKS with the if then statements its just slow as a snail . I tried converting the code lines into a select statement. When I use the select case statements several of my test scenarios came up with the incorrect answer. Not sure why the code does not work on all of the scenarios when converted to a select statement. The reason why I am attempting to change this to a select case statement is to enhance the speed on computing the macro. Can someone tell how I can speed up this macro or tell me what the select case statement should look like for this code.

Nick,

I have an excel table with 2 columns - client & contact. There are 0..n contacts per client. I want to do a vlookup and get all the contact names (comma separated). How can I do that?

Thx
Laks

Hi
I want to have a default formal in a cell, if the user of the sheets enter data is there, if he then again deletes the data, the formal reappear.

e.g.
A1. – Formal ”=b1+c1”
User enter 5,
User deletes the data, and then the formal is there again.

Hi all,

I have 2 sheets, 1st sheet contains data of city and customer columns and I have more than 200 cities and each city has more than 50 customers.

In 2nd sheet i have same columns and If i select a city from drop down list the customer column drop down list should contain customers names of that particular city..I have done this by creating lists but it is complex for maintaining huge data so i want to implement this using macros.

So, plz help to achieve this using macros.

Here is my sample data

sheet 1

city customer

a ggg
a jkhy

When using formula [=VLOOKUP(A2,Orders!$H$20:$I$22,2,FALSE)] are situations when the results are FALSE and in output cells is produce FALSE.
How to avoid that, and insted just have empty cells?

Hi all,

I have a problem on conditional formatting with date and time.

I hava a cell A1 that has date and time and I want to conditionally format its adjecent cell if the value of cell A1 is greater than 3 days compared to today, then cell A2 should show as "Follow-up Required" and cell colour should turn red no. if cell value of A1 is less than 3 days compared to today, no action is required.

Please help.

Regards,
Kiran

http://www.chegg.com/homework-help/questions-and-answers/p-i-need-help-v...
here is the link of the problem please help

Dear forumers,

I was trying to save my .xls as a comma-delimited .csv file. Unfortunately, the Cyrillic characters were not recognized.

Has anyone ever had the issue?

I'd appreciate your help!

Help please i need to make a vba code with generate quotation button and another vba code for Add to invoice... those are in the page 4 of the pdf

1. Create the master lists
2. Copy and transpose the list headers to this sheet (shown in red)
3. Add a Form control - > listbox (The left one)
3a Right click the listbox and select Format Control
3B sET THE inputrange as $B$20:$B$25.. (I usually include one blank on the list)
3b Set the cell link as $G$4 - (This is the selected index of Listbox 1 shown in Yellow)
4. Go to Functions -> Name Manager on the ribbon
4a Select "New"
4b add the function OFFSET(Lists!$A$9,1,Sheet2!$G$4-2,10,1)
4c Give it a name - "SelectedList"
4d Save it and exit name manager

Hi all,

I have struck with updating drop down based on previous cell value.

Here is my problem..
I have 2 sheets.. 1st sheet looks as..

Locale OS Version Size
US win7 10 30
US mac 10.7 10.1.4 45
Japan win7 10 78
Japan mac 10.7 10.1.4 90
Japan mac 10.8 11 80

In the second sheet the same columns..

Is this what you are looking for ?

In excel, I have a list of names and the column next to it is the number of times the person gets their name in a drawing, (ex. John Doe, 15). How can I get from the list to the winner without having to type out all the names and randomizing them?

I've been using the method/function described here

Help to generate simple visual dashboard from data table

Dear all, I once had a much more complicated problem and someone on this forum solved it within hours so I thought I would give it another try.

[Note that the details of my problem and objective are included in the attached worksheet.]

Hello Sir,

my problem is i forgot the password of personal.xls and i am not able to edit my macros without password. could you please suggest me hot a solution for this.
thanks in advance.

manish

Hi guys..

I need ur help here.

i want to develop an inventory workbook that can automatically update the balance quantity for every input or output items.

Every item has their own code. what i need is, when i input :

A) item code in E6 (sheet1)
B) IN or OUT process in E8 ( sheet1)
D) quantity in E10 (sheet1)

then the formula can automatically lookup the necassary item from column B (sheet2) and update the respective inventory in column H (sheet2) based on values in step B and C above. These 2 operations means.

if E8 = IN

I have excel 2007 and I am needing to make a line graph showing year on year variations in attendance for different sporting classes. Example below

Name of Class 2007 2008 2009 2010 2011
Ballet 40 75 80 15 3
Kung Fu 188 12 89 33 78

I would really like all the names to be in the left hand column and be spaced apart enough to show if a program is doing better/worse/or staying the same year on year. Any help would be greatly appreciated!

Good evening,

I am new to VBA and am very unsure how to accomplish the following procedure. I have a table of values (positive and negative). I would like to create a macro to take a user input value (which is a net of various values from the values table), scan the values table, and return any and all combinations of values that could possible make up the user input net value. Does anyone know how I can do this? Thanks!

HI,

I wish to merge two cells if the value of an adjacent cell is blank.

Pl refer the attached for your quick understanding.

Your help is highly valuable.

Probably formula [=TODAY()] explain everything, but I would like to make it continuously changing, let say every 2 minutes, or better on every click command, from chosen date for sample: 1/01/2000 to the chosen date for sample: 31/12/2015.

Is it possible??

Hi Team

Please find the attached Query sheet.

I have some 100 documents in column-A of sheet-1.
I have to distribute those equally between say 4 operators as shown in column-B.
Operators' list is placed in sheet-2.

Please let me know if there is any smart way to do this rather than copy-paste each operator name and then duplicating down.
Please suggest a pure excel way without getting into vb scripting.

Thanks & Regards
Kumar.

Please find the attached tested sheet.

Thanks & Regards
Kumar.

I have a few inquiries for this specific sheet. I am working on a project where I need to track each time my team receives an issue from a customer. If there are updates for the same customer, they need to be logged separately from the initial entry.