Excel Forum
-
Identify same values in Column A [Closed]
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...
-
Inserting different photos into cells- macro [Closed]
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 [Closed]
how we can convert number to word in excel?
-
Need to create a macro [Closed]
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 ...
-
Shape not showing Text in excel [Closed]
I moke a shape in excel I wrote text in shape but when I click on another cell the text disappears. Please Help!
-
If Function [Closed]
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...
-
Number that turns in to date. [Closed]
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...
-
How to repeat a row 4 times, while increasing sequence [Solved/Closed]
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 ...
-
Using one cell to refer to many [Closed]
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 ...
-
Creating a task reminder for all tasks for that day [Closed]
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...
-
Converting rows of data in notepad to columns [Solved/Closed]
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...
-
Excel [Closed]
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...
-
conditionally copy columns [Solved/Closed]
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...
-
convert Nov-11-2014 to dd/mm/yyyy in Excel [Closed]
Hello, I need assistance, Need to convert the following date of "Nov-11-2014" to dd/mm/yyyy Configuration: Windows 7 / Firefox 35.0
-
find word on Sheet1 move all adjacent column values to sheet2 [Closed]
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...
-
Change a range dynamically - VBA script. [Solved/Closed]
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...
-
logging [Closed]
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...
-
copying info [Closed]
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...
-
If formula [Closed]
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...
-
details to another worksheet fr main worksheet using macro [Closed]
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 ...
-
Date not showing up as a date??? [Closed]
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 ...
-
Ms. [Closed]
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? ...
-
Conditional Formating [Closed]
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...
-
Macros code [Closed]
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...
-
Macro for transferring data from one excel to different excel [Closed]
Hi I need macro for transferring data from one excel to different excel. Here I want to transfer data from "Book" = "temp", "Sheets" = "auditreport...
-
Looking for help with a macro/vba for find/copy/paste [Closed]
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...
-
Enter current time in a cell by clicking it [Closed]
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...
-
If function date problem [Closed]
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...
-
Comparing two lists of names in Excel and then sorting them [Closed]
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...
-
Can I accomplish this with Conditional Formatting or another way [Closed]
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, ...
-
excel [Closed]
Hello, I Want to change date format dd/mm/yyyy to dd.mm.yyyy in MS Excel 2003 Please solve my problem urgently
-
removing false in excel [Solved/Closed]
=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!
-
VBA UDF for Color [Closed]
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...
-
Increment a cell value - conditions applied [Solved/Closed]
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 ...
-
Michelle [Closed]
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 ...
-
want to copy sheet1 data to sheet2 [Closed]
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...
-
Apply a negative until 0 is reached in Excel [Closed]
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...
-
How to merge the data from 2 different sheets into 1? [Closed]
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...
-
Rating from Parameter Lookup [Solved/Closed]
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...
-
Nesting if() functions? [Solved/Closed]
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...
-
Excel macro create new sheet copy & paste cells [Closed]
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 ...
-
automiatic email [Closed]
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...
-
transfer data [Closed]
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. ...
-
Copy data from one workbook to another workbook using vba [Closed]
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...
-
HELP HELP HELP Excel Formula [Closed]
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...
-
Due Date Reminder With An Email to the filtered list [Closed]
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...
-
Change date format using Excel Macro [Closed]
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...
-
Comparing Excel sheets with only a few overlapping records [Closed]
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 ...
-
Mtch formula required [Closed]
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 ...
-
How to make a cell flash using Excel 2011 for Mac [Closed]
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...
Subscribe To Our Newsletter!
DON'T MISS
- How to Recover Your Yahoo Account
- How to Get More Followers on Instagram
- Computer Boots to Black Screen
- How to Disabled Write Protection on a USB
- How to Create a Gmail Account
- How to Recover a Disabled Facebook Account
- How to Fix a Blurry Snapchat Video
- How to Upload High Quality Photos to Instagram
- How to Install a VPN
- How to Get Free Diamonds in Free Fire
- Facebook Code Not Received