Excel Forum
-
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...
-
Find, copy, create a row under, paste, loop. [Closed]
Hello, I would like to ask for a macro (as I was unfortunate to experiment with a lot of them and none of them worked as I'd like). What it sho...
-
Excel - Merge several worksheets into a single one [Closed]
I use Excel to store information about several users and their cars information and have a different worksheet for each month. How to merge all these...
-
Replace cell content in Excel 2007 [Closed]
Hello, I've two columns like below and i'd like to replace the one in 1st column with the one in column B in another table. Name_A Name_B Joe ...
-
macros or vba for data validation [Closed]
Hi, I have a data in sheet1 with ID, name ,area, amount,January amt,February amt.....(below month column particular dates are mentioned) Anybo...
-
1 time data entry [Solved/Closed]
Hello, is there any way that make a condition for a cell which don't let to any body change the cell after they enter the date. i mean when i enter...
-
Add an X to cell if other conditions met [Closed]
Hello, I've got a list of products for an e-commerce site. What I'm trying to do in Excel is flag any items that have a quantity of zero AND are i...
-
convert numbers to words in excel [Closed]
please clarify my problem "convert numbers to words in excel"
-
mm/dd/yy AND dd/mm/yy AND mm-dd-yy AND dd-mm-yy in one column [Closed]
Hello, I have the problem of having all the 4 date formats in the very same column: mm/dd/yyyy dd/mm/yyyy mm-dd-yyyy dd-mm-yyyy I would nee...
-
transferring data [Closed]
Hello, Dear to whom it may concern, I want the data in sheet 1 to automatically export the data in sheet 3 and when the row is empty in sheet 1 th...
-
Replacing duplicates [Closed]
Hello Trowa Sorry to bother you again but a problem has arisen. Everything was working OK until I tested "Pair names 4" Column Q. When I ran the code...
Subscribe To Our Newsletter!
DON'T MISS
- How to Get Free Diamonds in Free Fire
- How to Install a VPN
- Facebook Code Not Received
- How to Get More Followers on Instagram
- How to Upload High Quality Photos to Instagram
- Computer Boots to Black Screen
- How to Disabled Write Protection on a USB
- How to Recover Your Yahoo Account
- How to Recover a Disabled Facebook Account
- How to Create a Gmail Account
- How to Fix a Blurry Snapchat Video