Excel Forum
-
How to stop today function date changing every day in Excel [Closed]
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...
-
Format cells [Closed]
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...
-
trying to create an order sheet [Solved/Closed]
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...
-
Help to automatically update data from a master sheet to another [Closed]
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...
-
add 7 days to a set date [Closed]
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...
-
Need to have a row of data automatically transferred [Closed]
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 ...
-
multiple if then statements [Closed]
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...
-
creating an order [Closed]
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 ...
-
Macro to copy data from a externalworkbook based on cell data [Closed]
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...
-
Exporting data [Solved/Closed]
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...
-
Add row below last entry [Closed]
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...
-
Conditional formatting [Closed]
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...
-
add data inputed from one sheet to anther [Closed]
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...
-
Conditional format to highlight cell based on date [Solved/Closed]
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...
-
Inserting rows [Closed]
Hello, I Want to Insert Multiple rows Between Existing Data Along with TRANSPOSE formula Configuration: Windows 7 / Chrome 40.0.2214.111
-
formula that will make a specific text into a number [Closed]
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, ...
-
Conditional Formatting [Closed]
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
-
Select a single line even if there are merged cells with VBA [Closed]
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 ...
-
Excel "IF" function with DATE in test cell [Closed]
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...
-
Keeping data [Closed]
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...
-
How to separate data between sheets [Closed]
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...
-
VBA search column for matching string [Solved/Closed]
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...
-
enter date in dd-mm-yyyy [Closed]
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
-
Capturing & Keeping Data [Closed]
Need help capturing data from continually updated spreadsheet. Specifically, sales $'s are tracked by customer until payment in made, then deleted...
-
need a formula [Closed]
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...
-
negative cells [Solved/Closed]
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...
-
Extract data from specific cells and paste into a row [Closed]
Our sales department has been using an Excel spreadsheet template to update product specifics, then printing it out and sending to our typesetting dep...
-
code for transferring data [Closed]
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...
-
Excel Calendars and how to modify them [Closed]
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....
-
calculate no of days left from today to a future specified date [Solved/Closed]
Hello, How to calculate no of days left from today to a future specified date Configuration: Windows 7 / Chrome 52.0.2743.116
-
compare two sheet on weekly to see if any data is missing [Closed]
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...
-
Merge Rows and Seperate Data with Semicolon [Closed]
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 ...
-
adding new sheets based columns and moving rows to sheets [Closed]
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...
-
Copy data different sheet with multiple columns with same header [Closed]
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...
-
Selecting all colored cells VBA [Closed]
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...
-
Formula zero return [Closed]
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
-
help regarding a pricing sheet [Closed]
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...
-
Changing colour of cell once multiple other cells contain text [Closed]
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...
-
Count if formula [Closed]
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...
-
format the color font depending on the value of another cell [Closed]
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 ...
-
VBA looping/range [Closed]
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...
-
how do you custom sort data in a pivot table [Closed]
Hello, I need to sort the largest amount in a pivot table how is this done ? Configuration: Windows 7 / Mozilla 11.0
-
excel formula to move a word from one cell to another [Closed]
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...
-
Creating Remarks from grades [Closed]
How do I create corresponding remarks against letter grades?
-
insert row based on criteria in EXCEL [Closed]
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. (...
-
Creating a GANTT Chart with Calendar List of Tasks [Closed]
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...
-
Macro to make the same graphs on multiple sheets [Closed]
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 ...
-
Insert 1 result if a cell contains one of several possibilities [Closed]
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 ...
-
Copy values only when using a filter [Closed]
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...
-
Preparing a commission worksheet from an excel spreadsheet [Closed]
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...
Subscribe To Our Newsletter!
DON'T MISS
- Facebook Code Not Received
- How to Get Free Diamonds in Free Fire
- How to Create a Gmail Account
- How to Disabled Write Protection on a USB
- Computer Boots to Black Screen
- How to Recover Your Yahoo Account
- How to Recover a Disabled Facebook Account
- How to Install a VPN
- How to Get More Followers on Instagram
- How to Upload High Quality Photos to Instagram
- How to Fix a Blurry Snapchat Video