Excel Forum
-
excel copying rows with two conditions [Closed]
Hi I'm trying to create a dashboard - which will automatically pick up rows based on a condition. I.e. copy the row if its 'closed won' and if it...
-
Writing a macro [Solved/Closed]
Hello, I am trying to get data whcih has been inoutted into one workksheet to copy into another worksheets when it meets a command in one of the c...
-
Dates Formatting in Excel [Closed]
Hi All, Thanks in advance for your help. I am autoformatting my dates in Excel 2007 to read as mmm-dd-yyy (i.e. Jan-01-2010) which is working per...
-
Help! Please my interner browser wont open [Closed]
Hello, My name is Edgar I have a problem with my laptop. the internet browser wont start when i open the internet explorer it closes down by itself....
-
Excel, IF fuction with cell text values? [Solved/Closed]
Hello, I would like to include the text value of a cell in the statement I have for one of the IF options. So far my formula is -: =IF((B1...
-
req: 'IF' formula in excel [Closed]
Hello, In one of my excel formate below mentioned row/coloums are there, Disp. Month IPO # IPO Dt Customer Details Job Name PO No. PO DT Inv N...
-
Excel Formula Display in Cell [Closed]
Hello, I hope someone can help me. I need to print the step by step values of a formula in a cell for example ilets say: cells(A,3)= Cells...
-
Excel:Conditional Formatting Stops Working [Closed]
Hello, First of all i am using 3 rules in conditional formatting and those are =AND(c1"",c1today() Green it works perfectly but ...
-
Auto Email when cells in range are edited [Closed]
Hello, Heres my problem: The company I work for currently uses an excel spreadsheet for scheduling. Its annoying and cumbersome. Once updated...
-
Setting up Criteria for VBA Macros in Excel [Closed]
Hello, I need to set up a loop function that will only output the data of the cheapest house, with a pool. Here is what I have so far, but my...
-
Highlighting cells within a loop [Closed]
Hello, I am trying to set my vb code to highlight columns C through G in a light blue color after each step of the loop. So for instance my for st...
-
How to automatically copy data from excel? [Closed]
Hello, I am running a data entry office and I need some help with present project. here is the exact scenario 1. I have data ready in ex...
-
Excel Convert Number to letters [Closed]
Pls let me know how to convert numbers into letters in excel
-
Copy data from one worksheet to another [Closed]
Hello, Configuration: Windows 7 / Internet Explorer 8.0 I am looking for a way where i can copy data from one worksheet to the another. Th...
-
Excel-Formula [Closed]
Hello, Configuration: Windows XP / Internet Explorer 7.0 I have 3 columns K, L and M that 2 of the fields are n/a and 1 of the fields will ha...
-
Deleting cells based on cell value of samerow [Solved/Closed]
Hello, When I delete cell D4 (it's contents turn to ""), I would like cells C4, E4, F4, G4 to be deleted as well. The row must still exist, so on...
-
Excel Leading Zero Format [Closed]
Hello, I would like some advice on formatting cells to have leading zeroes. I do know about using ="0####", but my problem is somewhat more comple...
-
Assign macro to button on a multi-page tab [Closed]
Hello, This seems easy but I am really stuck. I need to have a floating set of commands in a spreadsheet and I can't use attached custom toolbars (IT...
-
List 2 columns into one [Solved/Closed]
Hello, I hoping that someone can help me fix this. I have two columns with possible duplicate vendor name, example VendorName ...
-
How to make macros in excel [Closed]
Salam All Dear any one help me to make macro inexcel I m very new in this field and i m copying some data from any web sit (i-e www.192.com) a...
-
Excel sheet [Closed]
Hello, If you have data stored in an Excel sheet, describe the steps to import the excel sheet into MS-Access and to convert the data into a datab...
-
I need a formula for excel [Solved/Closed]
Hello, Here is what I need and cant find anywhere: IF A12="text1 (anywhere in text)",then b2="text2" please help provide a formula that ca...
-
excel formula file linked [Solved/Closed]
http://wikisend.com/download/466894/Check1.xlsx Their is a description on the file about what i am trying to do. besicly check one value to a list,...
-
Excel formula to pull data between dates [Closed]
Hello, I have a worksheet from a payroll program that is exported into Excel. In column A it prints the date and then names, the next date and t...
-
Separating string into different columns [Closed]
Hello, I am working in an Excel Spreadsheet where I have a column that looks like this: Column XYZ Engineers #### Lincoln Ave., Suite ### San ...
-
Merge 10 workbooks in a sheet [Closed]
Hello, I wanted to create an application using macro. I have 10 excel work books, i wanted to merge that all excel workbook into one work book....
-
Adding double quotes to excel [Closed]
Hello, How do I add double quotes the beginning and end of a column of numbers in Excel. Example 45671 needs to be "45671". Thanks. Config...
-
Autofilling formulas from multiple worksheets [Closed]
Hi guys. I am decent with excel, but I am trying to help a fellow employee out at the moment who has very little knowledge of excel. She is doing a ...
-
How to copy data using macros? [Closed]
Hello, I have a sheet which has data, Sheet 1 A B C D 1 2 3 4 1 2 3 4 -- -- -- -- Now ...
-
Sorting data into different worksheets-Excel [Closed]
Hello, Here is my issue. I'm using Excel 2003, and I have a worksheet going with a list of names in column A, and their job title in column B. Wh...
-
Macro to compare and delete rows [Solved/Closed]
Hello, I'm a new b when it comes to macros. I'm looking for the best way to compare data in 2 sheets. If data in column A matches on both sheets...
-
excel formula if statement with link [Closed]
Hi all, so if cell a1:a50 contain 5 digit product codes, and b1:b50 contain prices on a serperate sheet there will be a list off 100 product coes fr...
-
Excel duplicates [Closed]
Hello, I have Windows XP, Excel 2003, and 2007. I use large Pivot Tables, using Multiple Consolidation Ranges, which are bank statements from...
-
Won't delete my empty rows! [Closed]
Hello, After I used the filter on my spreadsheet that only contained 650 rows, suddenely there were 65,000! But they won't delete. I've tried clea...
-
Unprotecting a sheet [Closed]
Hello, Is there anyway to unprotect a spreadsheet without knowing the password ? Configuration: Windows XP / Internet Explorer 6.0
-
Sort by columns [Closed]
Hello, I have been trying to create a macro to sort some arrival hours, I have 9 columns, the data I want to sort is on columns D, H and L, do you...
-
Match columns and bring back a third column [Closed]
Hi excel gurus, I have a problem and I need some help to match information in two spreadsheets, I need to match the first two colomns in sheet1 ...
-
Excel VBA macro to make sheets [Closed]
Hello, I'm looking for a macro that makes a sheet in the Excel-workbook. I have a mastersheet with all the persons working in a company in a partic...
-
Need macro for following condition [Closed]
Hello, I need help on the following condition. ID Type Time 1 A 2 1 B 3 2 C 1.25 2 D 2 3 E ...
-
Excel Fomula [Closed]
Hello, Trying to get excel to return a number only if it is in a range of two other numbers: A B ...
-
COLOR CHANGE AND CONTINUAL TOTAL...EXCEL!!!! [Closed]
Hello, I am begging for help !!!! I will explain what I need and then hopefully you can help me. FIRST ISSUE: If Cell F9 = E9 do nothin...
-
Macro to send email from Vlookup cell value [Solved/Closed]
Hello, I am trying to create a macro that will among other things send an email to each address in a cell. The only problem is that the cell with ...
-
a formula for comparing values in two columns [Closed]
Hello, I want to compare values in two colums excel, if the value is in both columns to return a 0, if not to remain as it is. kindly help ...
-
HOW DO I CHANGE DATES AUTOMATICALLY IN EXCEL [Closed]
Hello, Any clever person out there. I am a frustrated administrator. I need to forward plan with dates. Basically I enter a Date of Birth i...
-
Excel: Selection of Cells in column Between 2 [Closed]
All, Selection of Cells in a column Between two Values I am preparing a Statistical Data Sheet, for this I need to select and copy data from one...
-
Email Function in Excel [Closed]
Hello, I have created a spreadsheet containing Clients, invoice numbers, Due date for payment, Date reminder has to be sent to the clients and fol...
-
Excel macro to name ranges [Closed]
Hello, I have a spreadsheet which contains many DSUM criteria, and I would like to name each of the ranges so I can refer to them by name rather than ...
-
Add up the values of duplicate cells [Solved/Closed]
Hello, I am trying to sort out a problem in excel file. I have some duplicate strings in column C and there are some integer values in ...
-
office(Excel) 2007 shortcut keys [Closed]
Hello, Sir this is vivek, can anyone provide me shortcut keys for excel 2007. wud b vry gr8fl thx...Vivek Configuration: Windows XP / Saf...
-
Excel - Macro copy Date for "n" month [Solved/Closed]
Hello, Would you please help me to create a macro for generate Date schedule to Sheet2 It just like an installment schedule. Sheet1 Col ...
Subscribe To Our Newsletter!
DON'T MISS
- How to Get Free Diamonds in Free Fire
- How to Recover Your Yahoo Account
- How to Recover a Disabled Facebook Account
- How to Get More Followers on Instagram
- How to Create a Gmail Account
- Computer Boots to Black Screen
- How to Upload High Quality Photos to Instagram
- How to Disabled Write Protection on a USB
- How to Install a VPN
- How to Fix a Blurry Snapchat Video
- Facebook Code Not Received