urgent

Evening! (or morning to some of you!) I'm new to the site but have heard good things so I'm hoping someone can help me. I've put a spreadsheet together designed for multiple people to update/add to on a regular basis. When a line is complete a number is put into a specific cell (e.g. Z3), when...

Hi All, I need a VBA code with the below requirements. All my emails have a specific Subject line pattern. e.g. if the request is for Jason.. The subject line is "Issue with Desktop [JAS].. There are 10-15 such names and each one of them has a short name in the subject line of the email.. For...

Hi there, I am looking for a formula that will tell me the start and end date in excel based off whether the cells are populated. so in row 1 I have the dates Below I have filled in 1's where there will be work for that week. I want to know when the 1's start and when the 1's finish based off...

Trying to replace a macro for a conditional format. Can I use conditional formatting when I have a cell that is coloured - for eg. Cell BN30 is coloured in pink. IF that cell has a colour - I want that same colour to populate in cell BZ30. Is this possible? hope I explained well enough!! Thanks!

I have a highly complex spreadsheet that I have to long hand the formula. Once I create the spreadsheet and create the formulas I cannot modify the sheet, only cell values. If I insert a column, the end formula will not count the new column contents (but I can delete columns before the formula...

Hey I'm super new to this so excuse my ignorance! :) I have a userform created in Word 2010 VBA that I need a pop out box to appear once all the information has been filled in. For the purposes of this example we'll say the Userform has 1 label and 1 Textbox and I need to see the Label name...

Hi All, I have a group of huge data as follows. I want to create a macro to just choose the first immediate date of each individual (in another word hide the second rows onwards for each Name). How can i do it? Thanks in advance for any help. <TBODY> Name Travelling date A 2-3-2014 A...

Hey Everyone, I have an Excel document with two sheets(tabs). One is called "AnalyseData" and the other is called "New Table". I want to get the total of values in column K in "AnalyseData" WHEN: Column F in AnalyseData = Cell D12 in New Table Column D in AnalyseData = Cell B2 in New Table...

***I am having trouble attaching the Images as used in the following question, you can find them here: Google Drive MrExcel Folder including the Excel File Please forgive me as I am brand new to VBA, I only started researching and learning 2 weeks ago using Excel 2010 when I found myself in a...

Having some issues with the following: Can't quite get this to target a specific range (Columns E-G as an array. I would like each row to be validated against one another vertically but taking into account the collective info of all three columns, not just a cell-by-cell basis.) as opposed to...

Hey all, We are currently using an excel spreadsheet to upload data to a database. We formatted our cells to "text" so that the 0's in front of our numbers don't disappear. However, when you copy and paste something into that cell it changes the formating and the zeros disappear. Is there any...

HELLO GUYS, COMPLETE BOG STANDARD EXCEL INTERMEDIATE HERE! I HAVE AN ISSUE WITH A PROJECT IM WORKING ON, IF ANYONE HAS A SOLUTION PLEASE LET ME KNOW :) OK I HAVE A DOCUMENT WITH MANY SHEETS, I WOULD LIKE A SHEET TO MATCH TWO CRITERIA OF ITS OWN CONTENT, AGAINST ANOTHER SHEET THAT CONTAINS...

Hi, I have a sheet that looks like this: <tbody> GSM number Extension Group name Subgroup name Name GSM number User ref1 User Ref2 Call date Call time Call duration Destination Zone/Country/Operator Tariff Type Supplementary services Indicative tariff Usage amount Currency Country of...

Hi, i wrote this code to truncate a cell in a sheet, then rename it with the new value of this cell and delete the whole row afterwards. I need this to loop through all the sheets with the value of B1. here is what i have so fare but it doesn't seem to work. Dim workS As Worksheet For...

Hi there :warning: I have a spreadsheet which I just couldn't figure out what is wrong with the formula. The following arguments need to be in the formula. I want excel to show me (in row X) how long it took to issue the order. Beginning from the day, the order was created. If the order was...

Can some one kindly help me out. I have an existing summary (see table 1) which I wish to summarise as shown in Table 2. - I want a macro to automatically insert a row as soon the value is changed in column A (item) and than sum the total quantity of all items per category. Furthermore it...

Hi there i have a number to find from the data and return me the name of that product from the number but the problem is that number is in C column and the data name for the number is in A column so then how to i find the data because using vlookup gives me error because the data is in last...

Good morning. Can someone please advise if it is possible to have a note pad type box in Excel so that i could work on my main worsheet but also have this box hovering in the spreadsheet so remind me that i have other information to enter. Please help......

Hey, I have a chart with two sets of values: one in stacked column, the other a trend line that displays values over time. The date on horizontal (x) axis goes beyond the most recent data point I have for the trend line but I wish to include it in the chart anyway. The problem is that...

Hi ppl.. I need a help for the following using macro should write a pgm in macro where i should get * pop up in a form of window * 2 seperate windows , 1 . manager , 2. officer * 2 windows should have a drop down in it * the manager window should be PASSWORD PROTECTED when i give a password...