Hi, I am using this formula on my work sheet in cell (M7), and I have 13 sheets for each month in this workbook and I dragged the formula till cel...
Hello, I need to format cells based on date on another cell. for example if column A is complete then in Column B which is date column has to be g...
Hello, I am trying to create an order sheet in Excel. I have an inventory list with various information. One of the cells is where I input how may o...
Hello, Can somebody please point me into the right direction? Example: I have 12 Tow trucks labeled T30-T41. I have to keep track of all maintena...
i formated the column to the german setting 28.8.2016. i put the formular in =sum(A1+7) the result returns #VALUE! how do i get it to work? it w...
Example: I have 12 Tow trucks labeled T30-T41. I have to keep track of all maintenance done on each truck and the cost for the budget. If I have a ...
Hello, i am trying to write a ridiculous amount of if then statements (100+). i can nest them on a single worksheet no problem, however, trying t...
Hello, I have a multi sheet database where each sheet represents a vendor. I'd like to transfer the information from the row, Column A, B, C, to my ...
Hi everyone! I'm new here and have a question. I've been away from macros for 10 years and seem to have forgotten most of what I thought I knew. I n...
Hi am so excited to join this forum!!! Pls I need help. I have 14 sheets on a workbook (for 14 of the company's locations in Canada). The data c...
I want to create macro for adding entire blank row with formatting if first cell of last row is populated with data. My row is B32:AM32. If user types...
Hello, Can I use conditional formatting to change a number from positive to negative based on the text in another cell? For example, I have a fil...
I'm trying to do an inventory control spreadsheet where I can put the data (ex, inventory in hand, use, buy, etc and it will be saved in another sheet...
hi guys! I need some help. I'm creating a spreadsheet to show when car MOT expires. I have a column (F) which has MOT expiry dates in. I h...
Hello, I Want to Insert Multiple rows Between Existing Data Along with TRANSPOSE formula Configuration: Windows 7 / Chrome 40.0.2214.111
Hello, I need formula that will make a specific text into a number example: if A1 is R134a then B2 is 1430, if A1 is R404A then B2 is 3922, ...
Hello, if i type "T" in one Cell i want to be fill colour to entire row how can it possible Configuration: Windows 7 / Chrome 53.0.2785.80
Hello, I'm creating a worksheets that needs to be protected at all time. However, users may need to duplicate a line sometimes. What I want to do ...
Hello, I am trying to use the IF function with a date in the 2 logic test cell; If the 1st logic test cell has a date then I want the word "IN TRANSI...
Hello there, I have what I consider an interesting issue and would certainly appreciate some options for resolving it as I am no Excel expert. We h...
Hello, I'm don't know much about Excel in regards to functions and formulas, what I'm trying to do seemed like it may be a simple task but I'm le...
I am trying to write a script in VBA for excel. For an entire column of data in sheet 2, for each individual cell in a column, I need to search a c...
Hello, Please enter date in dd-mm-yyyy only. I have give 25-12-1988 but not accept Configuration: Windows 7 / Chrome 52.0.2743.116
Need help capturing data from continually updated spreadsheet. Specifically, sales $'s are tracked by customer until payment in made, then deleted...
on 1/1/16 (a1) , John (b1) told me he'd pay me $1 in 30 days. i want a formula that will automatically add 30 days from (a1) in date form in another...
Hello, Please would someone help me with what I think is a simple problem. I have a range of cells which decrease in value and some become positive n...
Our sales department has been using an Excel spreadsheet template to update product specifics, then printing it out and sending to our typesetting dep...
i Have an excel workbook with different sheets. In sheet 1, i have date picker, where i select date and enter all the data for that particular date. T...
Hello, I am doing a Calendar for my work. It will include 3 tabs. Tab 1 will be a list of events going on and the date that event will take place....
Hello, How to calculate no of days left from today to a future specified date Configuration: Windows 7 / Chrome 52.0.2743.116
I have two excel work books which we update daily. Since the sheets are used by multiple users, it is difficult to know if we miss any lines . Is ther...
Hello, I am hoping to merge rows in an Excel document based on shared Names (listed in a single column) and then consolidating the remaining data ...
I am new to Excel and need some assistance. Summary: I need to distribute cases to investigators from a raw data list. I would like to create a...
Hi, I am new to Macros I have situation where some column headers are repetitive like column Header XYZ repeats n times and column header ABC rep...
Hello, i want to create a button that once i click it, all colored cells RGB (255,178,178) will be selected. i don't want to fill them or anything...
Hello ~ How can I get a zero return instead of a FALSE statement with the following formula? =IF(F4>E4,(F4-E4)*24,IF(F4
Hello, I'm looking for help regarding a pricing sheet I'm trying to create on excel. I have my quantity in C5 = 2500 and cost in C15 = 75,000 if C...
Hello, I would like to indicate in a cell at the beginning of a row whether multiple 'mandatory' cells within the row contain text. Red for incomple...
Hello, I have a Excel file where i have specific paths of the files and i Need a formula where it should reefr that cell path and Count the rows w...
Im new to Excel. Is there away or formula to change the color font of a cell depending on another cell? I want my text in colum A B C to be the font ...
Hello, im attempting to run this but I want to add in separate loops that search for certain keywords. currently this successfully will find one and m...
Hello, I need to sort the largest amount in a pivot table how is this done ? Configuration: Windows 7 / Mozilla 11.0
Hello, Hi what is the formula to move anything that begins with "other: " to the adjacent cell Advocate at Home Advocate at Home Other: Bria o...
How do I create corresponding remarks against letter grades?
hi friends, i'll get same data in two different sheet with a small changes, i will compare sheet one and sheet two, to create new sheet eg. (...
Hello, Need help in creating a GANTT chart with a calendar function. For example, if according to the GANTT Chart Task 1 is due on the 25th of Octo...
Hello I have multiple sheets of data, all with the same formatting (although different numbers of data sets) formatted as a table. I am trying to ...
Hi All, I am new to this level of excel - but what I need is a formula that does the following : Insert if an adjacent cell contains one of up ...
Hello, VBA below, this is doing exactly what I want... however I can not get it to copy values only...not the formulas and a list which is in a co...
Hello, I am a payroll specialist. Every two weeks I run a report for all employees who have funded loans. I copy that information into another w...
DON'T MISS