Hello, I have an excel sheet with too many rows. But in Column A, I have many values which starts with XYZ. I have to identify them and need to use...
Hi, I am not a super savvy programmer, but looking for a Macro that might automate inserting a photo (so user selects image) and then re-sizing the ph...
how we can convert number to word in excel?
i have no clue on how to create a macro.i need to copy all items in sheet 1 rows to columns in sheet 2 every time its updated. sheet one will change ...
I moke a shape in excel I wrote text in shape but when I click on another cell the text disappears. Please Help!
Hello, I'm having a bit of a trouble working the If Function in excel. Here's my problem: My manager asked me to find the commission fees to cha...
Hello, hi I'm Nokuthula. I want to ask why when I try to put a number it turn and become a date. Why is that ? Configuration: Windows 7 / C...
Hello all, I need help on the best way to repeat this 4 times, and then increase the number at the end. I need this: Column A AAA_BBB_0002135 ...
Hello, I'm trying to do something I'm not sure is possible. I have a spreadsheet to keep track of receipts and group items by category. In one column ...
I'm hoping someone will be able to help me. I need to attempt to create a task reminder pop up that will list all tasks that need to be done today. An...
Hello, Needing help please. From a pdf data base supplied, I have copied the contents over onto notepad. The data within this notepad contains firs...
Hello, How to copy data from one sheet in a row containing formulas to another sheet in a column but not in a row still have the same data with it...
Hello, I have a table with thousands of rows of text. Column B has errors in the data which I have fixed in column C (has many blank cells). I would l...
Hello, I need assistance, Need to convert the following date of "Nov-11-2014" to dd/mm/yyyy Configuration: Windows 7 / Firefox 35.0
Hello, I have a list of accounts and information on items inside the accounts along with the account owner. It goes like this, A= account number, B...
Hi everyone. I am stuck on a small problem with writing a Macro in Excel and would appreciate some help. I have the following script: For...
I have a form that we have to manually insert data into. And I would like to log the data in a sperate workbook of list of 200 people. Logging it i...
Hello, How do I get information in one cell to two there sheets with out copy and paste. The info in the cells are the same on all three sheets bu...
This formula is killing me! I have a column of numbers E3:E12. These are dollar amounts of bills that have been paid. E13 contains the sum of t...
Hi, I trying to input my project data into my Master list. When we won or lost the project, the data will auto disappear and transfer to the Won list ...
Hello, I have entered & formatted a column as a date but shows up as a 5 digit number. I followed your instructions and it still showing up as a 5 ...
working with several worksheets in one notebook, how do I get amounts from sheet 1 plus sheet 2 plus sheet 3 etc. to total to the final total sheet? ...
I have several rows of data and a legend which needs to apply based on the mutiple values. The idea is that D1/D2 equals a % if that percentage is a...
My excel depends on date column.... I have used macros to calculate all my required columns. So when I generate data for today or tomorrow I get on...
Hi I need macro for transferring data from one excel to different excel. Here I want to transfer data from "Book" = "temp", "Sheets" = "auditreport...
I have a lot of data in column A of a spread sheet. I would like to "search" for part of a string, and then copy the row of the cell with this data in...
Hello, I followed the instructions and it works great. My problem is how do you turn it off with out deleting the visual basic entry? AJ Co...
Hello, i am trying to use excel to give me two values depepnding if its a monday or a wednesday i have a date box so every week a person will pu...
Hello, I am wanting to compare two columns of information containing names from two different excel sheets. Names that do not appear on both list...
Hello, I have two worksheets. I would like to enter values in a column of sheet 1. When any of those values match a value in a table on sheet 2, ...
Hello, I Want to change date format dd/mm/yyyy to dd.mm.yyyy in MS Excel 2003 Please solve my problem urgently
=IF(D5>=150000,D5*21/100,IF(D5>=100000,D5*15/100,IF(D5>=70000,D5*21/100,IF(D5>=50000,D5*7/1000)))) What,s wrong in this formula Please Help!
Hello, I'm sure my question is simple to most of you as I'm new to UDF. I've created the following UDF but cannot apply it across columns when I us...
Hello, I needed a formula to add a value to a cell when the cell next to it contains a value where that value is obtained by incrementing the value ...
Hello, I am Having enormous difficulty with my MAC keyboard operating in Excel. I feel i must have put the scroll lock on but cannot find any ...
Hello, hi there i am just new to excel and iam trying to understand by praticing by own i want to copy sheet1 data to sheet2 when im typing in she...
I am trying to create either a formula or a macro (which I do not know how to create) so that the following rule works: (1) If last row of data (ie c...
I currently have 2 spreadsheets which show payments from 2 different companies. I'd like to be able to merge them into one spreadsheet which updates i...
Hi.. I have some data that reference parameter to fill Rating in my excel sheet. The problem is those parameter are in Text Type. Here is the e...
Hey guys, I'm relatively new to Excel, so bear with me here. I'm making this spreadsheet to check if the payments of certain products are either la...
Dear Sir I need help in a macro to create a new sheets with colum A name and copy row cells to the new sheet. Name Age Gender XX 25 M ...
Hi all, I have used excel for years but never at an expert level. I am currently in a position where I need to view multiple tabs of data daily to...
I am working on a spreadsheet and I need to transfer the ending balance on one page to beginning balance on another page, for the entire tenant list. ...
Hello, Good Afternoon, I need some help to be able to complete the below task. I need to be able to copy data for 2 different tabs in an wo...
Hello, I really need help trying to figure out this formula, as I have tried so many different formulas and can't seem to find one that works. I nee...
Hello, Here I have a filtered list from Master Sheet to DueReminder Sheet In which column I represents Email address Now my motive is to se...
Hello, In SAP BI I have created a BEx Query. We can see BEx reports in MS Excel. Date format in the report is DD/MM/YYYY and I want it to be displa...
Hello, I have two worksheets (1 & 2) that have different info, with not many duplicate records. I need to identify the duplicate records. I can ...
Hello, In one column - A i have name for eg -Anuj Muchhala and another column B - Anuj & column C - Muchala - I want to know how to match maximum ...
Hello, I have Excel 2011 for Mac. Is it possible to make a cell flash using the Mac version of Excel 2011? If so, how is it done? I would apprec...
DON'T MISS