I'm trying to create an interactive spreadsheet where as a user is presented with a locked interface - that interface will have buttons and drop down list. So this is the idea...

Sales rep on a call - customer says I have X amount of users, X amount of bandwith, X amount of whatever. Then as the rep enters the info and presses submit - it spits out the recommended product and any cross selling services from other orgs.

I use to be able to do this in older versions of Excel or word, but this new stuff I can't seem to find how to do this?

I just took a basics excel class and some of the things excel can do that I have never used. I have several excel sheets that I have been modifying to include some automation successfully.

I have a sheet with a time calculation that I only want answered if it meets my requirements.

To calculate time past midnight I am using =MOD(b1-a1,1), this works well as long as A1 and B1 are filled. If are both are empty i get 0:00 but if only b1 is filled then I get b1 as the answer.

I tried
=IF(OR(A1=" ",B1=" ")," ",MOD(B1-A1,1))

Is there an easy way to convert H:mm to a fraction of Hours
I would like to subtract a finish time from a start time and have the result as a fraction of hours.
example:
Start 15:30 finish 18:45 total 3.25 hrs duration

This is what I have tried

Do While Cells(j, 1) = Cells(j + 1, 1)

Print #iFile, "0" & Left(Range("A" & j).Value, 2) & " " & Range("D" & j).Value
Print #iFile, "1" & Range("B" & j).Value & LeftPadZeros(Range("C" & j).Value) _
& LeftPadZeros2(Range("E" & j).Value)
j = j + 1
cnt = cnt + 1

'Loop Until Cells(j, 1).Value <> Cells(j + 1, 1).Value
If Cells(j, 1).Value <> Cells(j + 1, 1).Value Then
Print #iFile, "9" & Left(Range("A" & j).Value, 2) _
& " " & LeftPadZeros3(cnt)

Please see enclosed example. I am looking for a macro or other method to summarize the lines in the INPUT tab into the table on the OUTPUT tab. The original spreadsheet as 48,000 lines so no manual cut and pastes or copies. Any ideas welcome.

UPDATE: I solved the issue myself with one formula, which I was able to paste down the sheet once. Then I ran a pivot report and I was good to go. See enclosed spreadsheet col. J.

Hello, I have a tool which tracks the stats of meetings. Each type of meeting has it's own named range. When a new meeting is held, that meeting's range is pasted at the next available row.

I would like a button to allow a user to "Insert a new meeting" they would be able to select which named range they need, and the macro would paste this named range at the next available row.

I have attached an example for further clarity.

Need help with a formula or code that will copy data from a group of cells and paste it into another group of cells if a value is changed. In addition, I also need that group of cells being pasted to find the next available blank group of cells in a specific range to be pasted in.

Hello Team

Please let me know how to get the names for corresponding numbers.

The name table has been displayed @ B1 thru F3.
An example of name entry has been displayed in J6. That is a manual input corresponding to the numbers present in I6.
In a similar pattern/manner, could you plz let me know if there is any function to input names for the corresponding numbers. Names should be looked up from name table.

Looking forward for your smart response.

Thanks & Regards
KumarSreenivas A

Hello,

I have been reading various posts on the web in regards to running a macro that would insert product images in to a sheet based on a contents are in a SKU that is in a different column.

My sheet has an needs to have an image in Cell A3 based on the SKU code that is in cell D3 (my sheet has over 500 SKU's). All of my images are stored in C:\Images\ All of my images are named the same as the SKU that will be entered in to Column D.

I have a problem with the column -Item description in the excel file

I need to format cells there, so the Text within ,whill concentrate solely on one line inside the cell

I have long texts of more than 255 characters, which is the maximum limit of the width of a single cell in Excel

In principle I need to format the cells so that,
Because only so that I can move them to a text file confirm them in front of Affiliate Network Cj.com
Which in I want to put an advertiser's product list named lakenUSA

Hello Friends,

I am looking for a macro which will help me to merge data from different worksheets in different workbooks into one master file. I tried doing with some online search help but wasn't successfull. Can anyone help me out with the macro ? Do let me know if you need any more info.

Thanks

Hi,

It's a well-known fact that Excel 2010 has a problem in the use of semicolons and comma's for defining a range due to regional settings. Changing these settings doesn't resolve everything, however. What if you have to combine comma's and semicolons?
My example:
I need to use this formula:
=(GROWTH(G25:G33,AH3:AH14;B25:B33,AC3:AC14;AC15))
G25:G33,AH3:AH14 and B25:B33,AC3:AC14 here are non-adjacent cell-ranges, while the semicolons separate known y's, known x's and new x.

Hi
I want to get some figures from sheet1 to sheet2 using VLOOKUP. (I am ok with this). Then if this figure is less than 25, I want to print "25" in the cell (in sheet 2)and if it is over 25 then the same figure. How can I do this in sheet 2 on the values I get from sheet 1.
Tks/ulsk

I wanted to convert the file crosstabs2 into a flatfile like is done in the kong example. However, I was not able to understand the steps taken in the kong file and was not able to transfer the steps into the crosstabs2 file.

Can anyone help me with the VBA code for:
- transferring the crossfiles into flat file
- coding where the file might stop -> this crosstabs2 file might change in format so the code should know where to start and stop and adjust to changes.

In this description you can find the different steps needed to do this:
A1 frage
+1down to "interest"
+1down

In Excel, how do I reference a cell in a previous sheet within a workbook? Each sheet is a day of the year starting with Jan 1st. I record my sales in a cell and a month-to-date in the next cell. On the Jan 2nd sheet, I want to take month-to-date and add to my daily amount. In Jan 3rd sheet, i want to take month-to-date from sheet Jan 2nd and add to Jan 3rd daily,etc.

I need to process survey results (900 cells) by automating the following logic:
1. If the first two leftmost characters in the text are "a." (without quotes) then replace the whole contents of the cell with a 1. If they are "b.", replace the whole cell contents with a 2, etc.
2. The purpose is to replace 6 possible text answers that begin with a., b., c., d., e., and f. with, respectively, numbers 1, 2, 3, 4, 5, and 0.

I have a workbook set up where I've got 10 columns (for different demographic age groups), and multiple rows, one of data for each month. This will be an ongoing update... at the end of each month, new data will be added for each of the 10 columns.

There are several different metrics... i.e. several different tables. Each one has 10 columns, same demographics, same titles, etc. Example: 10 columns, one for Kids 2-4, one for kids 5-11, etc. etc.
Row 1 = Jan data, Row 2 = Feb data, etc.

Hi I have the following code in VBA i just wanted to click the print button on the print pop
and enter a file name ans save

Code

Call objIE.document.parentWindow.execScript("doPrint()", "JavaScript")

used SendKeys "(%{ENTER})" ***but it does not work

please help

I have try use VLookup but still didnt work.
My problem is much likely like this:

In Sheet1, have a long list of names (eg: from Row 1 till Row 62000), with many similar surname and many categories.

Hello All,

My Windows XP Laptop runs the ol'e 2003 version of Excel.

Can some kind genius please help me with combining the "IF", "AND" and "OR" functions. (unless there is an easier way).

I have tried numerous ways via Trial and E-R-R-O-R and there seems to be nothing over the internet on combining all 3 functions.
(most likely I have been going about it all wrong, obviously, which is why I haven't included any of my current workings)

Hello All,

My Windows XP Laptop runs the ol'e 2003 version of Excel.

Can some kind genius please help me with combining the "IF", "AND" and "OR" functions. (unless there is an easier way).

I have tried numerous ways via Trial and E-R-R-O-R and there seems to be nothing over the internet on combining all 3 functions.
(most likely I have been going about it all wrong, obviously, which is why I haven't included any of my current workings)

Dear Experts,

I have login to the IE browser and working all the functions. webpage changed After login to the website[displayed main page].I'm not able to get the tags or html elements from loaded page through VBA code. Here I'm getting initial page settings only.

Pl. can you help me to get the tags from loaded IE webpage...

VBA Code::

Set ElementCol = ie.Document.getElementsByTagName("a")

For Each link In ElementCol
If link.innerHTML = "Logout" Then
link.Click
Exit For
End If
Next link

I have a spreadsheet that has a column with alpha-numeric chars. Excel 2007.

ie: W -160 or L 136
The format is '1 alpha char ; space ; 3 numerical chars (could be +/-)

I would like to separate them into 2 columns.

1 column would be ALPHA and the other would be the numerical.

ie:
column 1 contains W
column 2 contains -160

Does someone know how to do that? Can they help me?

Hi, I'm trying to rank score on a score sheet but the final scores to determine placing are not in consecutive cells and the ranking formula doesn't seem to want to work. Can anyone help me out here?

Thanks

Hello all . I have a tool written in which the number of applications received per person is calculated on the basis of work pattern and work rate and total occupancy hours . The routine in which the remainder is calculated must run until the remainder is zero . But it does not, ie he hangs at 44 and then it's an infinite loop .

I 've actually tested with breakpoints , Rij4 is just bigger than aantalcellen4 , that's not it .

Hi all,

I'm creating a basic form or templateusing Excel 2010 where the user will fill out information (See attached screenshot) I'd like to incorporate two a check boxes, that when ticked, change the display of the second table, either adding, removing or splitting of of the current columns in to two?

If this is not possible it will be acceptable that when a checkbox is ticked, the title text at the top of a specific collumn changes.

Is this, or any variation of, possible using Excel 2010.

Many thanks

Dear Sir
I want to select an automatic colour scheme (font) for an Exel sheet. It has 3 columns with values. If the coloums are A, B & C I want to mark the higher value in red. If B is higher than A, B should be red. Again if C is also higher than B, then C also should be red... like that. Values should be read row-wise. How can I do this using a formula?
Thanks/ulsk

Hi Team,

I have one XML File "Formdata.xml" ,which is saved on local drive .I want to show this xml data on Excel file .

On excel , left hand side has parameter .and I want to show respective xml data on righr side as

ACCOUNT NO : XX

MOBILE NO : XX

Could you please tell me code How to show that on excel ?

So I'm a bit stuck.

I've got a range of columns that indicate salary brackets on my spreadsheet. eg column A is £0-10K, column B 11-20K etc

Then on the rows I have how many people for a particular area fit into each of these columns.

What i need to do is display in a separate column: what the number one salary bracket is for that particular area and then in a second column what the 4th salary bracket is. So that when you look at the data at a glance you can see that the top 4 salary brackets for each area. eg 10K-40K

Hi all, need your expert help on this. attached workbook has a coloum for date and expire date. I need a script or something to make the workbook sent automatic emails to 2 or 3 contacts when the date is expired. Can this be done? if yes, how can I trigger it to send mails? (Do i have to open it? or press a button? or excel automatically do this?) and one last thing if there are 2 copies of the work book does both of them sends the emails or only one sends it?

Thanks,
Sanjeeva