Excel Forum
-
Transfer data from excel sheet to excel sheets. Closed
Hello I have a table contains about 5000 rows and 4 columns. The columns are Date, Codes, Department and Amount. I entered one year's data in that ...
-
EXCEL FORMULA Solved/Closed
Hello, I'm trying to do a formula like: If value of celA3=sunday, then write dimanche Any help would be appreciated. thanks
-
Scroll mouse in ListBox Solved/Closed
Hello, I would like to know that How do I enable mouse scroll in listbox inside a userform. Thanks Configuration: Windows 7 / Chrome 46.0.24...
-
Date Change to dd/mm/yyyy to dd/mm/yy Closed
Hello, I Want to change date format dd/mm/yyyy to dd/mm/yy in MS Excel 2003 Please revert me urgently Configuration: Windows XP / Chrome 46.0...
-
Calculation of age Closed
Hello All, I have been trying to calculate the exact age of a person from two dates in Office 2007. In the first cell I have the current date and i...
-
create a summary table from a master table Closed
Hello, I need a formula to create a summary table from a master table as below : Item Des. year ...
-
Get other cells value Closed
Hello, I am stuck in a formula and I cannot solve it. Please I need help. I am making a survey on excel, and I need the result for a whole month ...
-
Compare Excel Sheet1 to Sheet2 and highlight changes in sheet2 Closed
I have explained my query in screenshot. Somebody please help me get this resolved.....
-
Export data from one sheet to another Closed
I need help. I have a form call Purchase Request from where I want transfer data to different fields in next sheet and then need to raise Purchase ...
-
copying cells if criteria is met Closed
Hello, I have multiple sheets with sheet 1 as the main sheet for entering data. A cell for entering a order number Cells for entering invoic...
-
Copy a 'Template' sheet onto multiple other sheets Solved/Closed
Hello, i have been trying to create a sheet that creates new sheets from a list and i have been using the following macro to generate the sheets from ...
-
AverageIf function using dates Closed
Hi there. I'm trying to set up an average function based on dates entered in column a, for the data in column b. I want to use the data in b if the...
-
compare to columns in v lookup Closed
Hello, hii i want to compare to columns in v lookup.. Pls advise ... Configuration: Windows 7 / Chrome 44.0.2403.155
-
Add Sheets to ComboBox Solved/Closed
Hello, Hi I would like to know that how to add sheets (which are exist in active workbook) in ComboBox used in Userform. Thanks Configurati...
-
conditional formatting on multiple criteria Solved/Closed
hi, i am trying to create an excel vba code for creating a conditional formatting where i want to insert colour on the basis of multiple rules. i am ...
-
Conditional formatting cells containing IF rules Closed
Hello, Cell D11 contains the rule "=IF(D4>0,D4,"0")". I have set conditional formatting on the entire spreadsheet to show that if value is grea...
-
Copy data from another sheet if the condition is met Closed
Hello, Can you help me how can I create macro that will copy the data from one sheet to another sheet in the same file? Wherein if the Posting Acc...
-
Transfer Data IF.... Closed
Hi, I am in the process of building a database for injury management (I am a Sport Scientist). I have a master sheet which is basically a monthly ...
-
Multiple formulas for multiple sheets Closed
Hello, I have multiple sheets with sheet 1 as the main sheet for entering data. A cell for entering a order number Cells for entering invoic...
-
Comparing columns in Excel 2010 Solved/Closed
Hello all: I have an excel spreadsheet with 95 columns. I want to compare column 1 to column 95 and highlight in column 1 any line item that is mi...
-
Set Rows Height also Exception in Range Solved/Closed
Hello, I would like to request that rows from 10 to 40 their height will be Set to 12.75 but exception rows 11, 16, 21, 26, 31, 36 height will be...
-
Sheet List Window Closed
Hello, I would like to request that If user want to go to specific sheet it has to either press shortcut key or click arrows button in the left ...
-
Comparing Rows on two worksheets and pull data into a new sheet Solved/Closed
My requirement is following: I need to compare Column A, B and C of worksheet 1 to column A, B and C of Worksheet 2 If Above condition is met then I...
-
Find duplicates and highlight them across two worksheets Closed
Hello, my request is somewhat simple... I have two list of contacts, name, business name, address, phone number and email address. One was provide...
-
Listing ignoring blanks and avoiding duplicates Closed
I have a query but need to send a sample excel file for that. How do I attach a file as I do not see any link for that. Regards. jsexcel
-
IF formula Closed
Hello, I've got this formula that is supposed to give me two values however when ever I implement it, it seems to just give me one value all of time...
-
convert a number to a letter code Closed
Hello, This is to change a number to a code of letters to hide info in plain site. if my code table is 1 = C, 2 = D, 3 = E, etc thru 9 = K a...
-
Conditional formatting based on text in two different cells Closed
Hello, I have created a table with column A,B and C containing text for a risk register. I want to format column C in colours (red,amber or green...
-
Excel: Get Value from Sheet 1 to Sheet 2 Closed
Good evening, I need help please about what I am wrong. I have Cells A6 to F6 in Sheet1 has formula in it and I was trying to get the value of tho...
-
Macro to tell which sheet in master workbook is empty Closed
Hello, I will be grateful if someone can help me with below code. The code - Sub Demo() Application.ScreenUpdating = False Sheet1.[F2].C...
-
today function Closed
Hi, i am using today function in excel, i don't want change the date, when i open other day, it should show the previous date. Thanks Bbbp
-
Remove (Shape) Straight Line Solved/Closed
Hello I would like to request how to remove straight line shape through vba It was made through the following vba code Sub Str_line() ActiveSh...
-
Macro to tell user which sheet in master workbook is empty Closed
Hello, It would be helpful if someone can change a code to work as per my requirement. The code - Sub Demo() Application.ScreenUpdating...
-
Formula to count the duplication of a value in a range Closed
Hello, I am looking for a formula that can count the number of duplication of a particular value in a range of cells. Example: I need to know the ...
-
Macro to copy some cells in a column to another column Closed
Hello, I am trying to copy some cells from a column and post the value in another column. The column the values are posted to will vary depending...
-
Home Button Solved/Closed
Hello, I would like to request for the Macro which always take to "Sheet1" and also deactivated at "Sheet1" Thanks & Regards Configuration: ...
-
Next and Previous Button and De-Activate at Last Sheet Solved/Closed
Hello, I would like to request to create a button on Sheet that will click which goes to next sheet and this button also de-activate when it g...
-
Insert Custom footer - seems like a simple macro but won't work Closed
Hello, Simply trying to get any new workbook/sheet to insert path and file in the footer of the page with short cut key ctrl+shift+E. Below is th...
-
=IF(L9+M9>=40,10,) =IF(D8>=5,-40,) how do I make this work Closed
Hello, =IF(L9+M9>=40,10,) =IF(D8>=5,-40,) how do I make this work? Configuration: Windows 7 / Firefox 42.0
-
Positioning teams for tournament Closed
Hello, I'm creating a spreadsheet for a netball tournament and want it to calculate the finishing positions (1st, 2nd etc) based on the points sco...
-
macro to rename sheets based off cell value Closed
Hello, I have a workbook that I copy each month with dated sheets I would like to be able to rename each sheet based on the date.
-
Apply one macro to multiple rows Closed
Hello, So I have a question ragarding VBA. I have a sheet in which there is a column of dates and a column of values. When I input a date it retur...
-
Students Package Payment control Closed
Hello, I have the following columns then on SHEET 2(Students Sign Up control) I have a Sign up sheet I enter the student information like na...
-
Copy paste in excel sheet with macro based on matching column Closed
Hi, i have two sheets. sheet1 and sheet2, i want copy data from sheet1 in to sheet2 based on one matching column.i have one column called index w...
-
numerical into text Closed
I have 2.35 figure but i need to see two dollars and 35 cents in english
-
Need a formula to count the duplication of a value in a range Closed
Hello, I need a formula that can count the number of duplication of a particular value in a range of cells. Example: I need to know the count of ...
-
Spreadsheet Closed
Hi everyone, I have a question regarding this problem. I want when I enter in one cell code example: C.1.1.2., C.1.1.3, C.1.1.4. ..., that my other...
-
copying data one excel sheet to another with transposing columns Closed
We have a spreadsheet with rows and rows of data. Let's say column 1 is name, column 2 is address, column 3 is phone number, column 4 is rep name. L...
-
Select Cells from Column A which are hyperlinked to Sheets Closed
Hello, I would like to do the following: 1.Select Cells from Column A in "Index" Sheet which are already hyperlinked to Tab Sheets in the curre...
-
A macro to create new spreadsheet and copy data Solved/Closed
Hello, I m a University student and currently learning VBA programming. I have a VBA coursework where i have a file with 63 sheets. is any macro w...
