info

Hi, I was hoping that someone could give me the code for thefollowing. I wanted a pop up box for users to fill in 4 columns ofinformation. Col A would be “Date” B “Site” C “Tonnage” D “Reason” isthere a way that it will auto fill the newt row? So row 1 has the header titleso the info would need...

is there a macro that once an external file is open it pulls certain info from it and plugs it in to various sheets?

Hi everybody, Im hoping someone can help me with a little code to add to this workbook in order to get it to perform the way i would like. I have a database that i am able to export from our online tracking system that contains a list of users along with the sites that are assigned to them to...

Ok guys, I am going to try and explain this clearly this time. I have a spread sheet, in column A there is a list of words. There is a button on the spread sheet, we will call the button tst. The layout for column A is a word, then some cells containing info then another word. The words that are...

Hi All, I have the below formula, and the coloured words are name boxes. What I try to achive here is to have a shorter formula which pulls the info from those ranges, instead of adding each column to the formula. = IF(U5=HighestRatesTech,580, IF(U5=MidHighRatesTech,475, IF(U5=Z19,370...

sharepoint 2013 and excel 2010 if i go to File -> Info -> Properties -> Show Document Panels i have metadata of Title: PostGrad: if i key in ttt to PostGrad metadata and save and close Excel, back on sharepoint page i see ttt in PostGrad column. so i know the...

Hello, I have been getting help from your forum for quite a while, but I've always found the answer. This is the first time I needed to ask one. I have a spread sheet where I am trying to show the average percentage over a few cells. I'm trying to make R10 average out R5:R9, but to ignore -80%...

I am dragging some data from various sheets and presenting it on a single line =IFERROR(VLOOKUP(H5&"|"&B5&"|"&D5,comments!$A:$B,2,FALSE)&" ("&TEXT(((VLOOKUP(H5&"|"&B5&"|"&D5,comments!$A:$D,4,FALSE))),"dd/mm/yyyy")&")",Z5)&IF(AE5<>""," //-// Picking info: "&TEXT(AE5,"dd/mm/yy")&" "&AF5,"") If...

Hello, I'm trying to develop a macro that updates/generates the footer/header of excel files for my company. The first version of this macro uses a sheet to store the required info (pics, text) and it works. I want to go one step further and eliminate the sheet where the macro info is stored...

Hi, is there a way to do a vlookup between 2 different lists where the "multiple" hits are returned - rather than only the first one? (we were using the vlookup, but it only gives us the "first" reference that it looks up) What we'd like is for the 1st instance to be put in Col B, the...

hi, is there a way to concatenate the contents of multiple cells together depending on IF certain criteria? EG we have "item names" in Column A and their corresponding "order codes" in Column B So sometimes we can have a plug, but it has 3 different order codes. Is there a Marco or Function...

Hi All, Hi All, I need a formula to calculate the following in column D (example of returned info in there): Only bring across the cost (Col C) info from Red (Col A) that is more than £5.00, all others show 0 inc Red, Blue and Green. I need it for a summary at the bottom (if possible) or...

Hi Folks, I am requesting help on the formula :confused:I can use to lookup on worksheet-2 and will populate the info I need for that reference info. See table below for better appreciation. WORKSHEET 1 <tbody> A B C D E F G 1 Engr Name ENGR GRADE ENGR RATE 2 JOHN *FORMULA NEEDED...

Hi all you experts out there, I have a load of info regarding accident at work Ideally I would like to use the info in a pivot table, having never created one I really need advise. Can anyone spare the time to create one so that I can show areas, times etc so that I can just show a slide...

Hi all, Thank you for taking the time to view my question. I am looking for a way to attach the hyperlink which i have in my clipboard to an image i add with this code. Is there any one who can help me out with the last part? thanks! Private Sub InsertWord_Click() Dim clipboardData As...

How would I write a formula that would do this: Look in column A. For the rows that have the same number, look in those rows in column E. If those rows in E all have a same entry filled in, say yes. If not, say no. Further explanation: Column A will have 5 digit member ID numbers. Sometimes...

Hi everyone, I've got a problem that is very straight forward that is beyond my abilities. It is as follows: I have a sheet that tracks all expenses and info regarding them (Date of expense, check number, expense item, dollar amount), where all info regarding a particular expense is stored side...

Hello everyone. I have created an excel workbook where I write down our daily patients. I would like those daily info to be stored in a database, from which I'll be able to draw info next time those patients visit again. <tbody> ID NAME Father's name Phone RN 1 Mike Aaa 1001 12345 2 John...

What's the best way to do this? I need to create a Daily Summary Report based off of the info I enter on the Monthly Production Sheet. I am wanting to just enter in the date at the top of a blank template and have that days info pop in. I'm at a lost of how to do this. Thanks!

Good morning all, Ive searched for a answer for my query but alas cannot seem to find one, can someone help please. I have a sales order due data export that I put into a simple pivot table. What I am trying to do is show a total value for orders overdue. I thought this would be simple enough...