I'm trying to automate the ability to copy from Excel into a predetermined webpage.

One the website each field has a specific name followed by a number until it reaches the end of the line and starts over. I dont need the Hiredate filled in as i has a automatic function that does this for the whole page.

(ie ntlogin0 firstname0 middleinitial0 lastname0 hiredate0 )
( ntlogin1 firstname1 middleinitial1 lastname1 hiredate1 )

The data in excel is basically each item is in it's own column

firstname middleinitial Lastname column 4 column 5 NTlogin

Hi,

I want to get weighted average of supervisor's AHT without using "Sum Product Formula"
Data is in attacted Format.

Kindly help me ...

Hi All,

Please tell me if the below are possible and how.

1. I want column "A" in worksheet "SUMMARY" to change the location where it get the values according to the current month. In same workbook I have worksheets with each month of the year. I want Column "A" in "SUMMARY" to get in MAY the values from worksheet "MAY" Column "A" and next month in Jun the same column "A" in "SUMMARY" to populate with values from column "A" in "JUN" worksheet and so on.

I have started a basic spreadsheet. The only problem I am having is trying to figure out how to set up a conditional formula for expiration dates. Basically, 14 days before expiring, I want the cells in a column to change to a different color. However, when I set up the formula all of the dates change color regardless of the date and the blank cells change color as well. What am I doing wrong? I am ok with the other columns. It is column N that I am having trouble with. Thank you in advance.

I would like a formula based on the following
if possible.
Cell A1 is entered with any number from 0 through to 360.
Cell A2 is entered with any number from 0 through to 360.
Cell C1 is to return the number based on the following conditions and Cell D1 is
to return either e or w based on the conditions.

As an example, the SUM in cell E10 of worksheet “A” could lead to two different formulas :

1. =IF(E10<100, . . . . “use formula “x”, or
2. =IF(E10>101, . . . . “use formula “Y”

In which case the result would reflect in cell E11 of worksheet “A”.

Question: Is there a way to use one dedicated, collective worksheet, ea. worksheet “B”, for these and other formulas that I could refer to like in above formula 1. and 2. If “yes”, how ?

Thank you for your advice.

I would like to know if there is a formula that will achieve 2 things for me.
Cell A1 is where an amount is entered and shows in cell A2, I want the amount in cell A2 to show either an amount less than $75.00 or lower depending on the entry. If the amount entered was more than $75.00 than I would like the formula to show a maximum amount of $75.00

Is this achievable? I would so appreciate any help on this please.

Rabetz

Q) Enter 6 values into a array then count total number of even and numbers.Then display into shift1?
Ans)??
Please give a answer code and also give a explanation and show me in excel sheet snapshot.

I would appreciate it greatly if anyone could help me figure out how to do the following:

I have a spreadsheet wherein I track the return dates of projects which are identified as "past due" depending the following formula:

=IF(TODAY()However, I want to also add to the above formula that if column Q contains the wording "FINAL" then the word "Final" should replace the word "Past Due"

Hi Friends

Requesting your help for the below in excel. For ease of convenience, I attached the example in word attachment to retain formatting.

If S.No is same (e.g. 123), Kick is present in G2, then C2 (e.g. ABC) should be present in Column C for the same S.NO.
Based on above, C2 is repeated in C5. Then date in D5 must be on or after D2 date and before F2 date (since D2 & F2 are corresponding dates of C2 where initial ABC is present. If F2 had been blank, then D5 must be within 10 days of D2).

Regards
Krishna

I am trying to write a macro code that will repeat x number of time based upon a cell in my excel spreadsheet. Let say I have a cell with a range name as PCH and PCH tell me how many time I want to do a task. So I need to know how I can get VBA to read the range PCH and repeat the operating based upon PCH value.

Thanks

Hello,
Can you suggest an Excel methodology to set up Mathematical Equations for the following Twin Conditions (as mandated by the Regulatory Authority).

Twin Condition I for TV Broadcasters for selling their content to Cable TV Service Providers :-

To Sell their content (TV Channels) to MSOs (viz. Cable TV Service Providers) as a Bouquet (Packet), Broadcasters have to abide by the following Twin Conditions :-
A> Bouquet Rate > = 66% of the Sum of Ala Carte Rates (Standalone) of the TV Channels

Hello everyone,

I'm trying to create a simulation, but I'm stuck, at the 4th formula it doesn't work anymore, could anyone please tell me why (same with the bonus percentage if at least 4 territories are counted)?

Thank you so much.

AD

I want to change the graphs in "Graph" worksheet to change automatically when a new row is inserted in "Data" worksheet.

This can be done by formula or macro or vba. Any help highly appreciated.

I require a formula for the following...
For example, assume
Cell A1 has the number 10
Cell A2 has the number 8
Cell B1 has the letter N
Cell B2 has the letter N

So, I need a formula for Cell A3 to return a result based on these following conditions.
If B1 and B2 = N then the lowest number in A1 or A2 must be subtracted from the highest number in A1 or A2.
It B1 and B2 = S then the lowest number in A1 or A2 must be subtracted from the highest number in A1 or A2.
If B1 and B2 have a different letter, that is, one has an N and the other an S, then add A1 and A2 together.

I have a spreadsheet that I will be asking people to fill in to look at their county's school policy.

County Policy

County | Component 1| Proof| Component 2| Proof
Baker | No | N/A | Yes | "No tobacco is allowed on property"
DeWitt | Yes | "Enforcement plan established" | No | N/A

All:

First, Thank you. I am not the best at excel, but I do try....

I have created the bulk of the worksheet, and I am now on the summary page. My challenge for the summary is looking up when someone's name appears in Column A on any of the sheets, then summing the hours per week that the person worked.

The main sheets are to track hours, and billable dollars per project, but the summary is to track total hours per team member per week to make sure staff is being full utilized.

Hello Friends,

Looking for Help with VBA.

This is one of my daily office task.

Requirement:
In Column A ; Cell A1 Contains the date for which i want to pull the prices.
In Column A; From Cell A2 are the Security ID for which i want to pull the prices and Put Under B2. ( for some 200 funds May vary).

I have tried to built the code but its not correct. I have done till Login into website but don't know how to extract data from webpage table only for the date mentioned in Cell A1.

How to get solution for Excel auto guessing Column data type(Without changing Registry)

Hello people.

Can you help with this problem I have been stuck on for quite a while now.

My data set consists of 2 columns: A - the points name (of which there is about 11)
B - date and time (DD/MM/YYYY HH:MM:SS) (should be every 15 minutes, multiples of 15: 00, 15, 30, 45)

the data set is a whole month

So, each point should have a date and time every 15 minutes, however, sometimes this does not happen. The minimum is that every point should have at least 1 reading every hour.

I wrote, the function I copy at the end of this mail but it works correctly only when I put a Return in each place were it is used in the spreadsheet but not automatically, it also do not work when a change in a cell is made.

Can you give me an advise to modify it in the way it can make the calculations in all the spreadsheet when I modify a content of a cell

Will appreciate your help

Thanks

Jorge
jorge.ayllon@yahoo.es

Function RMES()
ce = ActiveCell.Column
ci = ce
re = ActiveCell.Row
ri = re
vce = Cells(re - 1, ce)
If vce = 0 Then RMES = 0: GoTo 100

I wrote, the function I copy at the end of this mail but it works correctly only when I put a Return in each place were it is used in the spreadsheet but not automatically, it also do not work when a change in a cell is made.

Can you give me an advise to modify it in the way it can make the calculations in all the spreadsheet when I modify a content of a cell

Will appreciate your help

Thanks

Jorge
jorge.ayllon@yahoo.es

Function RMES()
ce = ActiveCell.Column
ci = ce
re = ActiveCell.Row
ri = re
vce = Cells(re - 1, ce)
If vce = 0 Then RMES = 0: GoTo 100

Dear sirs,
good morning.

I would like to know if its possible for you guys to help me with this code, since I have no clue how to do it.

The attached file is self explanatory, so please download it and take a look.

Thank you very much!

Since I cant find the button to Attach a file, I uploaded on my DB: https://www.dropbox.com/s/s6034gcb3zwn3j3/Example.xlsx

Thank you a lot!

JMelo

Hi Excel gurus,
I've been pulling my hair out trying to do a potentially easy code for some experienced people, if anyone can help!

I'm looking to :

1) Open multiple file names from my F drive.
Details - With the file name of "issue303661.txt" the following file would typically be consectuive e.g "issue 303662.txt" but not necessarily.
Is there a way to have a simple macro that opens all text files in F drive no matter the name and inserts each text file into different worksheets that are space delaminated.

2) Renames each sheet to a specific cell

Hi there,

I have a 3 sheet model: inputs, outputs and data

In 'data' i have the following table with 4 columns (1 rating, and 3 options for pricing)

Rating Building 1 Building 2 Building 3
0.45 £100 £200 £300
0.5 £120 £210 £310
0.55 £130 £240 £315
0.6 £140 £250 £318

In Inputs tab, is a calculated rating figure (i.e. 0.47) and a drop down menu that a user can select either buiding 1, building 2 or building 3.

Hello there,

I have to creat a diagramm which displays on the left y-axis concentrations of nutrients and on the right y-axis the watertemperatures. on the horizontal x-axis at the bottom I want to show the time with specific dates.
The data of the temepertaure was measured every 15minutes over 6 months. The nutrient concentrations were measured only twice or three times in the last 3 months (so I already put the value "0" in all other data points which were measured every 15minutes).

Hi to everyone.

I need help with this code.

I have an excel with four pages (page1,pageB,pageC and pageD), the last 3 pages are empty, and the firstone has this:

            A            B                      C                   D

Hi,

I am trying to copy several filtered columns from an Excel file to another.
I have the code to do this, but I think it needs some refinement (or re-written from scratch?!).

I think that when I copy data from a column (source file) to another column (destination file), it copies the entire column (row 1 to row 1,048,576) and then the calculations in the destination file are slow (the processors are working hard even when I do only banal tasks like filtering or data input).

Within Column D, if the total is taxed by 17.5%, we should get the same amount as the total in column G. Why is this not happening. Please see attached sheet.

Help needed to fix spread sheet.

Problem:
Please see sheet attached; I wrote the following MS Excel (2010) syntax in cells D2:D11 to help me determine the "Earliest start date” (column D) in the range of each project ID number (column A):

=IF(C2="","",(SMALL($C$2:$C$11,1)))