Hallo I have data in this format: Please help me with a macro that will convert it to this format : This macro should run until all the da...
Hello, I have a spreadsheet that has a whole bunch of "½" in it that excel doesn't recognize as the number "0.5". Currently I have to manually cha...
Hello, I have an excel file that has 2 sheets of relevant information that I need excel to logically determine line up and from there automaticly ...
I have built an accounting program three columns of which are named Vat Number, Debit, and Credit I need that each time I make an entry into any cel...
I am trying to format the dates in Excel. The spread sheet is used for pay roll and as an example in row 4, column c and column f, I would like to hav...
I am new to this, and never did codes for Excel. But I need help. I have a workbook with 4 tabs: Summary, Project A, Project B, Project C. On Project ...
Hello, Hello everyone, I have an exercise about if function in excel. Honestly, I did pretty well the previous assignments but this one is much com...
Hello, This is my problem. Example: A1:E1 contain multiple text & number If F7=0 then A1:E1 change to RED If F7=1 then A1:E1 change to G...
Hello, how do we convert numbers into words in excel Configuration: Windows 7 / Chrome 40.0.2214.115
How do we convert numbers into words format in excel
Hi I have a macro in progress of development to create pivot table based on a constantly varying number of row labels eg "A1", "B16", "B32", "C18" et...
Hello dears, I will be glad if you help me in resolving the below brain challenging case An excel sheet with 1000 rows for unique names and wha...
Hello, Brain challenging question!! What we have here is an excel sheet with 1000 rows for my clients generated by system for my client's produ...
Hello Experts, My problem is as follow: We're reinstall an Laptop With Windows 7, but the user does not back up a folder, This folder contained ...
Hello, I am hoping you can please help me with a query in excel that I am stuck on. I have 2 workbooks, one with raw data the other used for report...
Hello, I have everything working but removing the image before saving. The code is not working and not even sure where to place it. (using excel...
Hi all, I have two worksheets. Namely 'Worksheet Values' and 'Worksheet Final'. 'Worksheet Values' contains all the data that I want to insert in...
Hello, I have two columns. Column A is for expiration dates, and Column B has a drop down menu indicating the status of an request (eg, pending, a...
Hello, I need to move a date if 21 days great than today Configuration: Windows 7 / Internet Explorer 10.0
Hello, I am trying to work out a formula if possible, to determine a date based on a date in another cell. So if the Date in Cell A is 3/1/2015,...
Hello, I am working on a spread sheet whereby one cell contacts REV and RP and I then want the amount linked to that row to become a negative figure...
How I can create any amount in word format from numeric format automatically or using the formula function in MS Excel Sheet? Kindly showing easy ...
Hello, I have my date format as 01.02.2015 but when we replace the . with / it shows as 01/02/2015 which is 02-Jan-2015. I want to show it as 01-F...
Hello, I'm looking for a formula that will help me do the following: If cell contains "Other (please specify)" that value of that cell needs to...
I have 2 workbooks, one with raw data the other used for reporting. The workbook with the raw data has 2 columns one being publication number and the ...
Hello, i have some data rows almost 2000 there is black rows between every row. filter did not showing whole data in drop dawn so i can remove empty...
Hi forum I am new here and I need excel tutorial, can anyone help?
Hello, is that possible to know the date that i enter the data in a cell. for example i enter the data in cell B1 today and i want this date in C1 ...
Hello, I have an internal budget and I would like to use macro to generate another workbook with specific information from that budget with formul...
Hello, I have a excel report that contains data including a date created and inception date. I would like to run a formula that will tell me if the ...
Hi! I'm Jen..I know how to use the Excel, however, I haven't use it for years now and my Job now is Secretary so I will be encountering Excel, Word, P...
Hello, sir please tell me in detail steps of converting date to words
hi Guys, does anyone of you know please how to replace the multiply sign with a divide sign in all of the formulas in an excel sheet? I could not f...
Hello, i want calculate the salary of workers like the following example. worker No.1 salary/hour 1$ working hours this week 3:45 (3 hou...
How can I transfer the final column totals from a rental data sheet to a specified place on another sheet in same book ?
Hi, I need to know, how to search similar entries in list of numeric entries. eg: Suppose I have numeric entries of 6 digits each having number...
I have a spreadsheet that is sorted by Facility, then Financial Class, and then Patient Type. I need to only have 0-2 rows of data for each Patien...
Hello, I would like the following thing to do: I have one sheet in which I have a value from and a value to. For example from B4= 104 (from) B...
Hello, I have a requirement for a macro wherein I need to select values(numbers) from the left(the first available number) and fill it across the r...
Hello, I have one workbook with a sheet that has a column that will have each day of the week for an entire month and the colums after will be cat...
Can anyone please help me with this!! conditions are: If column A is between B+1 & B+2.5 then its green. If column A is > B+2.5 then its red. If ...
Hello, I have a data dump where i need to run a macro which will segregate selected data to another worksheet: For e.g. Title Date/Time Resource...
Hi, I'm trying to count how many times did 1 cell from a row has been changed from 1 to 0 and then back to 1, how many times did this form of change h...
Hello, I am attempting to do conditional formatting in Excel 2013. I am trying to make Cell C 3 turn red if cell 1 is 25% less or greater than cell...
Hello, Please help me how to create a new excel file and copy data into this from other excel file. The new file filename will be a column.xls from ...
Suppose i have a file name tan.xls and another file names rule.xls! then i want to copy all data in tan.xls file in cell D2 - D22 to rule.xls file in ...
I need some help that could possibly save me a huge amount of time. I'm new to conditional formatting and am working on a new method to help my staff...
Hi all...I would to get help from here as I trying to input my project data into my Master list. When we select won or lost under the status for proje...
Hello, I hope someone could help me with this issue, i have a field TN1 and want to copy the one TN1 and replace the first TN1 with 375 and then rep...
I'm trying to enter the time in a column by clicking