Excel Forum
-
Change sheet name but not the cell references Closed
I have 5 sheets representing 5 days in a week. Each day i change the content of sheet 5 and then i have a table in a 6th sheet that orders data from t...
-
Excel formula help Closed
HI, I need help in finding a formula. I have 2 spreadsheets, in spreadsheet B column B I have a list of inventory item names that were sold. In s...
-
transfering data from one sheet to anothfer Closed
Hello, Guys I have two sheets in a workbook, sheet1 is the entry sheet and sheet 2 is the database sheet. am suppose to transfer data from the entry...
-
wants to copy data from one excell to anthor Closed
Hello, i want to copy the data from one excel to anthor excel. i have the program but i am facing some error in that. kindly help me on this. ...
-
virtual self calculating time sheet Closed
Hello, i am wanting to set up a time sheet on excel to automaticaly formulate hours worked and calculate the amount earned
-
Linking in Excel 2007 Closed
Hello, I need help that I want to create an excel file (say A) for the users for registration of incoming and outgoing letters and entries of that...
-
Dynamic highlighting of rows Closed
Hello, I have a list of 200 names in sheet 1 and in sheet 2 i have more than 5000 plus names, with all the details like adress, phone number ,etc....
-
how to hide specific rows automatically Closed
Hello, I'm a freshstarter at excel, so I'm in trouble!!! I have a worksheet with a table between data, the sheet has data on top and at the botom...
-
Multiple macro button Closed
Hello, In my excel i have 5 macros performing different task eg:- hide sheet, sort rows, etc. I have added 5 different buttons in my excel assigning...
-
Please help me Solve the macro Closed
I have a sample copy of macro where i have different sheets named Data,High,Med,Low In data i have sample regards with HIGH,MED,LOW in the colomn ...
-
Hi-lite rows with at least 2 matching columns Closed
Hello, I've tried lots of searches but keep getting answers for rows that match exactly. I need the opposite. I have a spreadsheet with 3000 rows....
-
Macro for changing tab color Closed
Hello, I have a list that prints out every day with different goals listed for people who work with me. I have a worksheet for each person on Excel...
-
Data filtering from one worksheet to another Closed
Hello, I have a excel worksheet with inventory data in it. Column A is Item Number Column B is Type of Coating Column C is Stock Level to maint...
-
Can I modify excel or word doc on the iphone? Closed
Hello, Is there a way to modify a word or excel document once it has been emailed to my iphone? Sometimes when I go out on a sales call I need to ...
-
Conditional formatting of a column of cells Solved/Closed
Hello, I am working on a task list/project sheet and I am trying to set a conditional format for a column of cells that is based on two (technical...
-
problem moving records to another worksheet Solved/Closed
Hello eberybody I have a doubt, I know how to move records from one sheet to another, as this: Worksheets("Sheet1").Range("A" & i + 2).Resize(1,...
-
Excel formula Closed
Hello, Sheet 1 22 1234 12 Sheet 2 1234 Yes 1234 Yes 1234 Yes 1234 No 1234 Yes 1234 yes 1234 Yes 22 Yes 22 Yes 22 Yes 2...
-
Transfer records to another worksheet Solved/Closed
Hello, I have tried everything to move these records to a sheet called "Data" , but I wasn't able to get any good results. what I have been trying...
-
Extra cells removal. EXCEL Solved/Closed
Hello, Does anyone know how to hide unused cells in excel? I have got a program that does all the matching for me, but everytime when i finished ...
-
link cell to another worksheet Solved/Closed
hi there, What i want to do is to link a worksheet to another worksheet. Like, when I type data on cell in sheet1... then, same data will auto...
-
Help - Excel 2007 Closed
Hello, Kindly assist - my excel freezes everytime i try to work with 3-4 worksheets and usually occurs when trying to copy paste data across diffe...
-
Excel Formula Closed
Hello, What formula to use in excel if i want to find a value in particualr cell satisfying more than 1 condition.say,i have date range in column ...
-
how to compare two excel worksheets. Closed
Hello, Iam having two excel sheets as below. file 1 --------------------------------------------- sl pol no loan amount name -----...
-
Macros to button in Excel Closed
Hello, I want to create two buttons a "Start Button" and a "Stop Button" in MS Excel 2007. Every time i click on Start or Stop in any active cel...
-
Excel Macro - Closed
Hello, I deal with spreadsheets in which I want to modify the data in column A. I need to delete the first 9 characters of each cell. The colu...
-
how to select the sheet name from ddm Solved/Closed
Hello, I want to select which sheet to store data from the drop down menu. thank you . Private Sub UserForm_Initialize() Dim i As Integer Fo...
-
Macro Help Needed Closed
Hello, I need a macro that will calculate complaint rates against sales, and the apply that macro against sales for x number of monthly sales, ...
-
can browse/cant connect to most sites srvers Closed
Hello, Hello, As my computer will not connect to this site, i am using an alternate one. I own a custom pc with an NVidia nforce networking controller...
-
Excel Formula of conversion Closed
Hello, Kindly mail me the formula to convert numeric value into english words in indian system in Microsoft Excel. For eg. Rs. 5551.00 convert int...
-
compare columns containing dates Solved/Closed
Hello, I have the dates and the close prices of 5 indices in 10 columns. I want to compare the 5 columns containing the dates in order to get the c...
-
how can i change my browser language Closed
Hello, iam using windows visa english version but my browser and the installed softwares are in german can i change those to english
-
Excel numerical value for multiple alphabets Closed
Hello, how to give numerical value for multiple alphabet in one cell for excel if i give 1520 in one cell the answer mustbe CEUD for example c i...
-
One cell calculation Excel - Time Interval Solved/Closed
Hello, I need to calculate the elapsed time in hours if the start time and end time are contained in the same cell. Example: If A1 contain...
-
Compare 2 worksheets Closed
Hello, I'm just new here and not an Excel expert. I have two Excel sheets with Names, address and other information. Here's the thing, not all na...
-
Date Format Quandry in EXCEL Closed
Hello, I am sorting data on excel and I have encountered a problem that I can't seem to overcome. My column with date information is formated with d...
-
Multiple Rows for 4 Conditional Formats Closed
Hi, I need to make four different color conditonal formats depending on a few statements. I know what statements I need, but how to I get it into ...
-
Help with Excel complex formulas Closed
Hello, Currently using MS excel 2003. I have the following formula thats generating a value of 0. If I do individual filters it will provide me ...
-
Hide columns and rows using count rows/colums Closed
New to VBA/Macros Trying to hide all rows and columns not being used in a sheet that has a fixed/finite design. Because this will be used in 200...
-
Using If-Then Function in VBA Closed
Hello, I wanted to make a macro so when column C has a certain number in a row then in column E, with the same row, it will insert a name. Ex. Whe...
-
Lookup table? Excel Closed
Hello, I am working from 3 different spreadsheets with meter reading information: 1-meter reading from date 6/8/2010 (Address|meter no|date|read) ...
-
Excel : Different Criteria for excel to look Solved/Closed
Hello, Please could anyone help? Attached please find the example. https://authentification.site/files/23122635/nono.xls The sheet (Say in doc...
-
Excel Macro Solved/Closed
Hi I am new to Excel macros, I need help with the following automation: I am trying to copy data from the main spreadsheet name "PMO Report" where...
-
mozilla browser problem Closed
Hello, my mozilla firefox is not working,when i click it to open it gives no response.same problem for chrome,opera.only IE is working which is very...
-
Find records in different sheets Closed
Hi everybody, I'm having a problem, Iam not an expert using excel and I don't know how to find a record in different sheets. In the sheet1 I have a...
-
How to compare two data (Excel) Closed
Hello, I have two separate data with same number of cells and locations (eg, A1:C10 and D1:F10.........or A1:C10 on sheet 1 and sheet 2) I want...
-
HELP!!!! EXCEL DUMMIE HERE Closed
Hello, I am trying to create a formular in excell and i dont ave a clue what im doing i have a spreadsheet with candidate information on row by...
-
MS Excel 2007 Macro/Formula problem Solved/Closed
Hello, ##Please help! I am new to this and so fed up!! I need to transfer data from two worksheets onto another worksheet and I just cannot do it!!...
-
Excel Macro Help Please Solved/Closed
Hello Everyone, I am sking for some help with an Excel macro please. I have a 1,900 hundred static HTML pages that I have converted to text for ...
-
Compare two worksheet, match with 2 columns Closed
Hi, I have a workbook with 2 worksheet (April , May).it consist of 4 columns for each worksheet.i need to compare column A and column C with May wo...
-
Compare two worksheet, match with 2 columns Closed
Hi, I have a workbook with 2 worksheet (April , May).it consist of 4 columns for each worksheet.i need to compare column A and column C with May wo...