This is a small utility to speed up the process of buying and selling between a Shopkeeper and a Customer. There are two sections (excel files) of it - Shopkeeper and Customer.

The Shopkeeper file as shown below remains with the shopkeeper where he can add/delete/modify items (Click Manage Items) and prices in the stock. 

The Update Customer copy button allows you to choose the other customer copy provided to be updated with the updated items and prices. This updated customer copy is then emailed/sent to the customer.

Following piece of code sort the data based on custom sort order. You can provide your own sort order in a separate table. For illustration, download the attached file.

Sub TestCustomSort()

    Dim rngSortOrder    As Range

    Dim rngSortValues   As Range

    Dim arrSortOrder

I am facing a problem at one place in a financial model which i am building. Let me know if any one can help me.

Regards
Saad

I have microsoft office 2010 starter on my laptop which i bought June 2011. I wanted to use my existing version of 2007 and installed and used it successfully since then. However, this week, and I haven't done anything, my laptop has started opening existing documents in 2010 version, and in the case of excel files isn't giving me the option to right click and open with 2007 excel version. How do I change my default setting back to the 2007 program? I assume this is what's needed. (I'm not technically computer minded). I can't even find the 2007 version in my programs!

I am trying to copy or move some work sheets from one file to another but when I move them they don't keep the theme colors and format. Could you please tell me how can I move them keepin all theme colors and formats.

Basically I have a column which has different buyer codes.

Eg:

EC51
EC38
EC51
EC38
EC74

I then have another column which contains either a hit or a miss.

hit
miss
miss
miss
hit

I need a formula which can count a particular buyer code with either a hit or a miss.
E.g. Buyer EC51 will have a total of 7 misses all together. I tried count if, but count if cant support multiple criteria. Please help!

Put the following code in a general module and run. You can download the attachment as well to see how it works.

Sub TestIt()

    Dim rngTgt As Range

    Dim arr

'Target where you want to see filtered data

    Set rngTgt = Sheet1.Range("J2")

    rngTgt.CurrentRegion.Offset(1).ClearContents

'Calling function with parameters

I used to be able to left-click on a row of rumbers and see the total at the bottom of the spreadsheet. A couple of months ago, that capability disappeared and I dom't know what I did to lose that capability. I used it a lot and need to sifure out how to reactivate that capability.

Dim PreviousValue

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Value <> PreviousValue Then
Sheets("log").Cells(65000, 1).End(xlUp).Offset(1, 0).Value = _
Application.UserName & " changed cell " & Target.Address _
& " from " & PreviousValue & " to " & Target.Value
End If
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
PreviousValue = Target.Value
End Sub

Private Sub Worksheet_Change2(ByVal Target As Range)

Need help on Excel macro--

Requirement: I need to copy data from one excel sheet and paste the data into new workbook and save with different file name every time under my documents.

I need to know the VBA code to make sure a field is not allowed to be NULL. If data is not inputted the field should return an error message of "Input Required" on that field.

I have taken over an excel sheet from my predecessor and he created it in windows03 but we are now running in 2010. When I press the save button it comes up with "could not load an object because it is not available on this machine" then I press "ok" then it comes up with "compile error, can't find project or library".
Next the screen coems up (picture attached). I feel I am very close for this to work but I can't figure it out.
Please help, thank you

This will record any cell change in the cell comment. There is a constant at the beginning of the code module; you can set the number of records in comments (history) to be maintained. Specifying 0 means no record limit. This applies to the whole workbook.

Const gc_intMaxCmtHistory As Integer = 5 'Max Comments History allowed

                                         'Change it to 0 to allow n no.

Hi Vishesh

Attach is the sample file you where looking for. I have add comment on the document if anybody else want to have a look at this as well.

Thank you
WesleyM101

Hi

I am looking to add tick boxes into a macro. It needs to work like this. for example a product header eg. R1006-TIM and below that are going to be sub headers for example. GSN and when you click on the button the GSN documentation will open but the problem that i have is that there is different GSN docs for different parts of the same item.

Hey

I am looking to put a search box into a excel macro that i am busy writing.

I have a page with different years from 2009 until 2013. if you click on any of them they will take you to that page and all the items of that year is displayed.

Now i want to add the search box on the page with all the dates to help people to get information but if they do not know which year it is in.

Can you please help me with that.

Thank
Wesley

Follow these steps to create a pivot table from multiple sources (same of other file). See attached example file.

Steps :
1a In Excel 2003 open the PivotTable and PivotChart wizard by choosing Data -> PivotTable and PivotChart Report.
1b In Excel 2007, press Alt+DP, then type P to open the wizard as there is no equivalent menu option.
2 Choose Multiple Consolidation ranges
3 Open file B as well
4 Choose relevant page field option
5 Simply select and add the ranges (highlighted cells) from this and other file. You can choose to have as many files (A+B)
6 Select New Sheet & Finish

I have a spreadsheet with Prices in one column and Lowest Prices in another column.
At the moment I have 100 instructions like this:
If Range("d4") < Range("i4") Then Range("i4") = Range("d4")
through to
If Range("d100") < Range("i100") Then Range("i100") = Range("d100")

I know there is a better way using If statements and looping through the cells.
Can I find the syntax or an example of how to do this - NO!
Is there anyone out there with the solution? Any help would be really appreciated.
H

Here is the example with notes attached

Hey

I need to copy data from sheet E-1 and past it on sheet Overdue.

The data that i need to copy shows have a value between -1 and -1500 and is in column Z. it needs to copy that entire row to sheet Overdue.

I want to create a button so that everyday i can update that data.

The other problem is that i am going to add remarks net to each overdue item and when i update the data everyday the remarks will not correspond to the origanal row. The reason why i am saying this is because items will be added and removed on the overdue schedule on a daily bases

I can't figure out how to do this except for the very long way. I have a column of about 100 numbers that I want to add. That I can do simply enough, however instead of just showing the final total at the bottom I want to show each step of the way. For example if I'm adding a column of 5 5's in the column next to it i would like to show 5,10,15,20,and lastly 25 at the end. Besides creating a seperate SUM function including the last cell, last two cells, last three cells.....and so on is there a short way of doing this?

Thank you in advance

Sir,

Please any one help me i need change row headings i.e, A B C D E F etc., i need to add DATE CHQ NO. AMOUNT etc.,

attachement is enclosed for your's ready reference.

I have an composite array of data in my Worksheet. I am using a Vlookup function to process the array for various algorithms which require data from the array. The composite array is horizontally divided by three rows of irrelevant data ("IR Data") into two arrays (upper and lower) which requires that the Vlookup function be initialized differently in the upper and lower array; i.e., the starting row of the lower array (below the IR Data) changes with varying output that populates the array.

This is the solution to blog on url
http://excelexperts.com/help

Please see attached xl file.

I'm new at using Excell. I'm trying to assign a numerical value to a letter in my spreadsheet.Can you walk me thru step by step? Or do you have a Video? Thanks

VENDORS PAYMENT DETAILS

1 2 3 4
SL.NO IN FAVOUR AMOUNT THROUGH

1 ABC LTD 30,000.00 DD
2 XYZ PVT LTD 25,000.00 CHQ
3 ZYX LTD 15,000.00 DD
4 CBA SOLUTIONS 2,000.00 CHQ
5 SOMU 8,000.00
6 RANI 6,000.00
7 RANGA 5,400.00
8 RAMANA 56,000.00

Sir

in above table i need to fill in 4th row only DD or CHQ not other characters of any like RTGS, Netbanking etc., how it is possible (details given in attached xls file)

Sir

How to apply Hyperlink from Word to Excel 2007

VINOD

At present the Sheet cells have a validation list where members of the team can only select 1 of 5 skill set options, however the background colour does not automatically update unless you actually activate the cell after making your selection. Can you please advise how I can get this to automatically update with each change?