I need some help please. I have researched and researched, but I cannot find what I am looking for. I have read almost every thread about this.

I need an excel document (or Access) that can help keep track of Transferred Items. I have 5 “Coordinators” that will be using this form to track Transfers from 130 establishments.

* I want the document to be locked anytime information is entered (they input data and then when saving it locks the row and cannot be changed).
* Which means the last row without data should have a “new” or “add” button that opens the row for them to use.

I am trying to make a pacing calendar for my employer, and I really like the Ion template that is embedded in Excel. However, it begins in January. There is a spot to put the year you'd like to begin, and it calculates everything from there. I'd like the calendar to begin in August. Because of the calendar functions built into the template, it won't let me make the changes manually, and I am not quite advanced enough with Excel to know how to fix those functions to carry over to the next year. Attached is a screenshot which shows the formula in question. I hope this makes sense.

I have this code:

dim PNexist
PNexist=xlapp.VLookup(xlWksLDSSConnector.Range("D" & rowIndex).value, xlWksxlWbkPNlist.Range("A2:A60000"), 1, False)
lastrow = xlWksLDSSConnector.range("B63000").end(xlUp).row
for rowIndex=4 to lastrow
if Range("D" & rowIndex)<>"" then
if PNexist="#N/A" then
xlWksLDSSFulfillment.Range("A" & rowIndex).Value = "ALU"
xlWksLDSSFulfillment.Range("D" & rowIndex)=xlapp.VLookup(xlWksLDSSFulfillment.Range("B" & rowIndex).value, xlWksMasterWO.Range("F4:N60000"), 3, False)

Dear all,

I start learning about excel in this semester and am doing an assignment on analyzing the manager performance in a company, I have imported the sales data from a database into the Excel and created two Pivot table reports to summarize the quarterly sales by department (i.e. worksheet “Dept") and by mangers (i.e. worksheet “Mgr").

Then, I need to recommend which manager should manage each department based on the data generated by the 2 Pivot Table reports, in which each manager should manager only 1 department only.

i Guys,

For the VBA code in the attachment below, if let's say i wanted to only copy and paste data matched by column headings, how can that be done?
What i'm trying to do is to copy all data under the specific column headings listed in MasterData sheet from the source file where the column headings match.

Can i also ask if how could the code be modified such that instead of column F "Copy to Sheet", i would like to copy to a new excel workbook instead with the spreadsheet named with variable "Item No"?

Could someone please help? Many many thanks.

Can someone help with this formula:
"IF" statement does not work in excel 2013:
=IF(AND(NOT(ISBLANK("B"&ROW())), (NOT(ISBLANK("B"&ROW() - 1)))),
SUM((INDIRECT("B"&ROW()) - (INDIRECT("B"&ROW() - 1)))),)

Windows Data Recovery is the top-ranking Windows data recovery tool to help Windows users recover lost data from various memory cards, mobile phones, digital cameras, USB drives, PC hard drive and other storage devices.

>> Recover various files including photos, videos, music and other documents
>> Support all devices like memory cards, mobile phones, digital cameras, computer
>> Recover Lost files in 2 modes
>> Preview data while scanning or after scanning

Download :- http://www.tools4recovery.com/

I'm trying to create a display on a sheet in excel 2010 that is driven by another sheet of simple data. The display sheet will show only one row of data at a time, whilst the source which is on another sheet selects the data row by row controlled by a time delay. The display will show time on a 24hr range and stop once it is completed. The data shown will be of three categories and show "out" or "back". Each category has the out or back set at differing intervals so the category 1 will have say 12 pairs, the second 8 pairs and the third 3 pairs. There will be times when a category is empty.

Excel 2010. I have a sheet of about 900,000 records in which there are about 90,000 I would like to delete. The rows are marked for deletion but I am not aware of a way to delete them and not have Excel hang there forever. I have tried filtering to the rows I would like deleted and cutting them, but that does not seem to be very quick. I have also tried just filtering the rows I want and copying them to a new sheet, leaving the unnecessary rows behind but that also is slow. Finally I have tried going cell by cell to do the deletion and again, it's painfully slow.

Hello, i didnt know that this forum exist. It looks like a good place to learn more about vba

I have a problem with autosort in excel, i want to order one table based on the date of one column,

Private Sub worksheet_change(ByVal target As Range)
On Error Resume Next
Range("D1").Sort Key1:=Range("D2"), _
Order1:=xlAscending, Header:=xlYes, _
OrderCustom:=1, MatchCase:=False, _
Orientation:=xlSortColumns

End Sub

How do I get rid of this?

Please explain what is going on. All I know is this might have something to do with it since I cannot copy and paste anything from my workbook to another becvause this appears on any workbook I copy over to. And I cannot get rid of it.

Essentially what I am looking to figure out in excel 2010:

-2 separate workbooks (1 full of data, other is a summary workbook)

-Need the summary workbook to create a row for every sheet in data workbook (data workbook can have anywhere from 1-? sheets- starts with minimum 1, and then sheets will be added throughout the year, sheet names will also be variable)
-In each new row, 3 cells from the data workbook sheet will be referenced.

I have created a picture of what I would like the end result to look like without any code.

Good Day to all
Long time ago I place a question regard a problem, and probably formulate the wrong question, that I have and can’t find a solution.

Need to identify and count the number of MRI Procedures complete in the day that were ordered; having the 7 PM of the day as the limit time to justify a next day procedure. In other word, I want to know how many MRI procedures ordered today - before 7 pm - are not done today but tomorrow in order to justify more employee past 7 pm…

This should be simple but I don't know if it "works" the way I think I want it to work.

Say I had a block of code like

Public Sub TextBoxBorderColor_Afterupdate()

Dim MyColor As Long
Dim oCtrl As Control

Select Case TextBoxBorderColor.Text

Call ColorCall 'I WANT TO PULL CODE FROM MODULE AND HAVE IT "PASTED" HERE - This isn't working it is expecting First case

Case Else: Exit Sub
End Select

For Each oCtrl In Me.Controls
If TypeName(oCtrl) = "TextBox" Or TypeName(oCtrl) = "Label" Or TypeName(oCtrl) = "Image" Then

Conditional formatting.

I need to apply two conditions to turn a cell to red and should applicable for a range:
- If any cell from a range misses due date AND
- If that particular cell of that range has value "1"

THEN ONLY THAT PARTICULAR CELL SHOULD BE "RED"

Now it does work if you use below format. problem is its only taking one cell at a time particularly for "value". example '1"

For due date the entire range works fine if i remove the 2nd condition

=AND($K$40Can anyone help?

First of all let me tell you all that i am totally new to Excel. I never used it before.. I am in a little trouble, so i need help of your guyz... Hope you guyz will help me.

My Problem is :

I have two columns "Sr.No" and "Previous Posting" as showing in the image1 (Current Situation).
Sr.No columns contains numbers in series and "Previous posting" contains all the posting details in the same column but in different rows..

Hey guys! First time posting here, hoping to hear some ideas from bright people such as yourselves . I myself am pretty much a rookie when it comes to VBA's but I have played around with macros quite a bit. Anyways I work for a card store and a lot of our sales come from online. We like to keep our card's prices as updated as possible, this involves going to Amazon, looking each card's price up individually and updating it accordingly. This takes quite a lot of time and would be much easier if we could simply look at one spread sheet that contains all the updated prices.

Creating an expense form. Need to sum numbers for subtotal, taxes, total according to type of Goods Purchased. What kind of formulas could be used to search criteria + sum numbers for Admin Use. Attached File...

Mitch

My spreadsheet formulas needs to be protected from changes. I locked the formula cells in Format,then selected Protect Sheet. This locks all cells from edit. The cells that are not formulas are unlocked in Format. I also tried the Allow Users to Edit Ranges. I input the ranges selected & clicked protect sheet. Again, the worksheet is protected entirely. What am I missing. Thank you.

I wrote a quite simple macro to use a png picture as a grid for Excel. It worked fine with Excel 2007, but now I switched to Excel 2013 and a small problem emerged:

Despite the fact, that the macro works, the png picture is displayed in another size on my second PC. The zoom is 100%, the setup of both PCs is identical. However, if the picture is displayed in different sizes it makes the grid worthless.

Has anyone any ideas? I want the grid picture always with the same size if the zoom equals 100%...

This is my code and it worked perfect with Excel 2007:

Sub MyGrid()

Hi please help me to extract city from address when no seperators where used
Eg:address is -'800 Town And Country Blvd Houston, TX'.i have to extract city from this.please help me to do this

So I've been trying to figure out how to display the minimum variance of a portfolio, but I don't know how to graph it using Solver (or any Excel tool).
I already added Solver and I have calculated the mean and standard deviation of the minimum variance portfolio in the end, but I also want to have a nice graphical display.

Also, how can one draw a tangent line from the risk free-rate (let's say 6%) to the opportunity set?

* The "s" abbreviation stands for standard deviation, I need to fix it.

Thanks a lot to anyone who is willing to share some advise.

Although I'm not a complete newbie to excel, I'm fairly new to VBA scripting.
I'm running Excel 2007 and I'm trying to acomplish this: (please see example below)
I need to write a macro that finds the substring "MLEA" in a row and add all values to the one that has the "MPRE" substring, then delete de "MLEA" row.
Please note that names are almost identical but for the MLEA, MPRE which defines the time spent on each function for this employee.

I dont really know if all this can be done through scripting, any help will be greatly appreciated.]
Thanks in advance

Ok I need a formula that:
Will calculate a 12.5% of A1 if H1 is Yes and calculate 20.5% of A1 if G1 is yes. is this possible. I can't figure it out. Please help

i want to know about how many room was occupied on the date.

Anybody can help me with this?
It works until I put username and password in the correct field but it doesn't seem to recognize the log in button? where am i wrong? many thanks

Sub ExcelExp()
Dim Htmldoc As HTMLDocument
Dim MyBrowser As InternetExplorer
Dim MyHTML_Element As HTMLElementCollection
Dim MyURL As String
On Error GoTo Err_Clear
MyURL = "http://excelexperts.com/search/node/"
Set MyBrowser = New InternetExplorer
MyBrowser.Silent = True
MyBrowser.Navigate MyURL
MyBrowser.Visible = True
Do
Loop Until MyBrowser.ReadyState = READYSTATE_COMPLETE

Basically I want to know whether an excel box lets say A6 which has on full name eg James D Lawson can be matched for yes or know with another cell say A22 which has the following details (rocky, Marry, Match, james, Stephen, barrack) is this possible and if yes then how??

Hi all,

I'm building a "configurator" tool for a sales rep. He just have to select some informations in the sheet1 "Configurateur" and he will have the part number, price and item description displayed in another cells. I want another worksheet (Soumission) with the output values of the first sheet displayed on the first available row.

Hi, I'm looking for a formula to help me do something very specific. I am not very well versed in advanced Excel language, but what I"m trying to do seems relatively simple. I have large finance tracking spreadsheet. I have the date in Column A, expenditure name in Column B, the amount spent in Column C and who of two ppl spent the money on that purchase initialed in Column D. What I want then is total the amount spent by person with initial J for the month and total the amount spent by person H for the month.