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?

Sir/s

I am trying to apply VLOOKUP formula from Anil to 19 (a to b)but it is getting only 71 not 19 but i need 19 how it possible or any other way.

a b

ANIL 71
ANIL 19
BABU 24
BABU 67

VINOD

Sir

I have one prob

a b c d

GANGAWATER BOTTLE TIN POCKET
GANGAWATER TIN BOTTLE POCKET
GANGAWATER POCKET TIN BOTTLE (this is master data)

I am trying to apply VLOOKUP a-b VLOOKUP is getting only BOTTLE(b) not for TIN and POCKET i need to pickup TIN how it is possible or any other root is there.

sir any one help me.

VINOD

Hi! I need help !!!

I have a spreadsheet in Excel that I'm trying to save as .txt or .csv to be able to import the data into myob.
However, every time I save as .txt or .csv and open it in notepad it doesn't show the data separated by comma, it's separated by tab which it's not the format accepted into myob.

What's happening ?? Am I doing something wrong ?? What should I do ??

I tried to concatenate the data too but it changes the date and numbers format...

Hi Nick,

Could u pls. assist with the below queries

1. When this file is closed and opened
the form control shrinks & expands- becomes steady only after a couple of scroll

2. When a particular item (parent/child) is selected
the same should get linked to a particular cell in the ctrl sheet

Thanks
Deepak Ji Paulson

Hello,

Help please !!! I have a excel work book with the following sheets , E-1 and Overdue.

The E-1 sheet consist of over a 1000 rows. I have a lot of formulas on that sheet to make certain items in colour and so on.

I need a formula or VBA help to get only the overdue orders on the E-1 sheet and copy them to the overdue sheet.

If the column AC is between -1 and -1000 it should copy that row to the overdue sheet.

If this formula is possible can we put in that column AC should be sorted from Highest to lowest.

Solution for problem posted on url

http://excelexperts.com/copy-range-data-new-worksheet-when-matching-data...

Please see attached sheet. Click on the button provided on the sheet.

Download the attached Excel workbook to see how the customised progress bar works. To implement this in your project simply copy the form (frmProgress) and general module (modProgressBar). And then, you just need to call ShowProgress procedure like this

Call ShowProgress("Task 4", 10)  

Solution for Forum Ques on url:

http://excelexperts.com/vishesh-need-macro-help

Solution for problem asked in url: http://excelexperts.com/moving-data-rows-columns-depending-unique-conten...

Pls c attached sheet. I have tried to solve it using formula only (no macros as it would need more involvement).

1576 tourist bed-nights multiplied by 100 liters of water per night

What would the formula look like in the formula bar?