Excel Forum
-
Place specfic text in cell based on text in an adjacent cell [Solved/Closed]
Hello Folks, Per the preface, I have a cell that has validation rules of "Concur, Non-concur". If the user selects "Non-concur" for that cell, I ...
-
Change format of a cell when another cell is not null [Closed]
How do I highlight a cell or row when another cell contains anything? Thanks!
-
every day the date changes [Closed]
say for example A1 is 9/4/2016 the next day when ever i open that sheet then the new date appear in A2 as 9/5/2016 the same continues on till the...
-
My spellnumber to Thai Baht. [Closed]
Hello, I Can change the Number into Spell but the problem is it does not convert in Thai Baht. Present Situation =SpellNumber(58.20) = Fifty Dol...
-
Entering Data in a column for prescribed number of times. [Closed]
Hello, How to enter a specific word from from one excel sheet into a column in another excel sheet for a number of times mentioned in the first s...
-
Conditional formating [Closed]
Hello, I'm trying to make multiple cells turn red if a single cell has a certain value. So for example is B3 says "abc" cells B3:F21 should turn r...
-
VB code for manual entry in range of cells [Closed]
Hello, In my work sheets the values in some of the cells in range are determined through formula. When someone wants to change the value manually...
-
blinking cell [Closed]
Use hyperlink addressing in Excel cells, to go to an other cell within same workbook. Can anyone advise how to program VBA to make the targuet cel...
-
Copying unique data that ends with a specific character [Closed]
Hello, I want to create a workbook that has a main input worksheet, then automatically copy new data that ends with a specific character to a spec...
-
using "if" in correlation with "date" [Closed]
Hello i'm trying to fill up specific cell on one sheet on a certain date and the content to go on another specific cell on other sheet. EG: on 3rd...
-
How to disable edit option once data inserted [Closed]
Hello, I need help can any one help me on the below query once data entered in excel it shouldn't edit by anyone Configuration: Windows ...
-
need to summarise data [Closed]
Dear All, Link to my document. https://drive.google.com/file/d/0B1ApeEMIB_lNVG12aWVmVzdLS2M/view?usp=sharing I need to summarise data as show...
-
Find duplicate rows and copy content of one cell to new sheet [Closed]
Hello, I'm totally new to macros and excel. I have an excel spreadsheet with huge data in it (over 9lakh rows). There are many entries that are ex...
-
Macro to add number of rows correspond with number in cell [Closed]
Hello, I need a macro that can dictate the number of rows to add after a line based on the number that is in the column. For example: Actually...
-
EXCEL - blank or contains zero [Closed]
Hello, I am looking for the formula to solve this issue and return my answer in cell D: if the value in cell A is less than or equal to cell B th...
-
How to send an email automatic when a cell is updated [Closed]
Hello guys, I am imports coordinator I have a tracker created in excel worksheet which I use to track our shipments that arrive at port then proce...
-
Monthly Calendar/Daily Schedule Automation [Closed]
Hello, I am looking for some assistance outputting data from a monthly calendar to individual daily schedules. I inherited this project that initi...
-
comparing data among excel sheets [Closed]
Hello, I have three excel sheets with data regarding product numbers and their respective plants as well as another sheet (4th sheet) which is a t...
-
Finding the @ character within a text, cell range [Closed]
Hello, I can't seem to find anything that's specific to what I'm looking for. I'm trying to find a formula that will tell me the following: ...
-
Adding points from one sheet to another [Solved/Closed]
Hello, I'm trying to record points that students accumulate in a club. In a GoogleForm, I check off the students (Estudiantes) that earned x po...
-
date issue [Closed]
if my year is only 1991 and i am trying to input the date by default 01-01-1991 in excel how? Am just doing manually 1-1-1991 and the system automat...
-
convertions [Closed]
i want to convert dd-mm-yyyy to dd/mm/yyyy or mm/dd/yyyy
-
create a registration log [Closed]
Hello, I am trying to create a registration log for a campground. It would be of great benefit if I could copy the registration info to subsequent ...
-
Excel - A Macro to move data from rows to columns [Closed]
Excel - A Macro to move data from rows to columns Thanks to Venkat1926 for this tip! This Macro is working well for me, but with the exception of...
-
Macro to repeat x amount of times - next row [Closed]
I'm trying to wrote a macro which writes a csv from lines of data. Currently it roughly runs: Copy B3:L3 Paste in A2 (new page) Copy A22 Paste i...
-
copy data of 1 sheet to another if criteria matched [Closed]
Hello, 1 have 3 sheet master, damage & shortage. in master sheet if i enter in n column damage then full row should be copied in sheet damage also...
-
Selecting all colored cells VBA [Closed]
Hello Everyone, i trying 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 the...
-
remove the date of 17/2/2012 from country A [Closed]
Hello, i have recently faced a problem in excel. my problem is that i have three country data on daily basis. i want the same date will be appeared ...
-
Conditional paste, based in colour. [Closed]
Hello, I'm looking to copy one value in one cell, following this condition: If A1 is green, then copy the value of C1 in B1. If not, leave it bla...
-
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...
Subscribe To Our Newsletter!
DON'T MISS
- How to Recover a Disabled Facebook Account
- How to Get More Followers on Instagram
- How to Fix a Blurry Snapchat Video
- Computer Boots to Black Screen
- How to Disabled Write Protection on a USB
- How to Recover Your Yahoo Account
- How to Create a Gmail Account
- How to Get Free Diamonds in Free Fire
- Facebook Code Not Received
- How to Install a VPN
- How to Upload High Quality Photos to Instagram