Excel Forum
-
Creation of dropdown from dynamic list using VBA Closed
Hi! If anybody could help me figure this out I would much appreciate it! I have been trying to make a Macro that can create a dropdown list from a ...
-
Creation of dropdown from dynamic list in VBA Closed
I have been trying to make a Macro that can create a dropdown list from a dynamic list in Rows 1-100. So far I've come up with the following code: ...
-
HELPP!! Simple MACRO help! Solved/Closed
Hello, I would like to create a macro that will scan sheet one for cells that contain the word "Complete", Copy the whole row, and paste it into a...
-
remainder from excel vba on desktop or task bar Closed
Hello, sir,i am venkat, when i am running the your giving I am getting task as empty, can you send whats the reason. Is it possible to get remai...
-
Formating Dates Closed
Hello, I am trying to do a VLookup between to spread sheets and having a terrible time with the dates formatting correctly. Each spread sheet com...
-
"IF" function with time Closed
Hello, I'm trying to do a function which will say if 0:15 minutes or less, the value will be 0 and for every 0:15 minutes the value is 1 for every ...
-
Fill color other fields based on start date and number of weeks Closed
Hello, I would like to add the color to other fields based on the start date and number of weeks fields. Ex: In the attached xl, for instance, for ...
-
macros Closed
I need to take info from sheet1 line a and copy & paste special on sheet 2 and every time i run macro to copy same way and paste on next empty line. T...
-
Two questions for cell color and sum Closed
Hello, Please need help. Using excel 2013 If in column E "personal" or "business" displays then in that same row the cell in column J must change ...
-
eXCEL Help Closed
Hello, I have a two rows that one of the rows contains values like A to Z I want to add the same in the second line how I can able to do this o...
-
Excel date question Closed
Im measuring monthly figures in predicted, vs actual values monthly. In my data base I have months, and years in separate columns. I need a formula ...
-
How Can put next day target on excel sheet Closed
Hello All, I looking for someone who help me to fix the target on excel sheet with the help of formula Example : 30 days in a month ...
-
IF function with dates Closed
Hello, I deal with parts on trains. For the extra parts NOT installed, we need to inspect them every 28 days to make sure they're still good. For thos...
-
Popup window when the Excel file is saved/updated Closed
Hello, I have an Excel file which is used by multiple users (saved on the network drive). They can only open the file as read-only. I'm looking fo...
-
Moving text from one cell to another depending upon criteria Closed
I have written a program to use in the field when taking bids on roofing jobs. I can input the quantity of material needed from a long list of potent...
-
Macro which should add a new Worksheet Closed
Hi guys, I have a question So I have a VBA Code which pretty much does everything it should. I can choose the CSV-Files, it deletes the columns th...
-
IF formula help Solved/Closed
Hello, I am needing a formula like this =IF(OR(B4="apple",B4="Banana",B4="carrot"),"yes","no") but if the cell B4 is blank. I need a blank " ". ...
-
Creating a payback calculator with rate change Solved/Closed
Hey, having a bit of trouble, appreciate any help. I am trying to create a payback calculator where you input: Initial Investment Rebates Annual...
-
Copy data from one sheet to another based on condition using VBA Closed
Hello, Please i need help on extracting some data in excel. The data looks like this A B C D 1 3.45 2.34 3.6...
-
Mind Blower: Search, Find, and Extract Closed
Hello there to this great community! Hope everybody is having a good week. My question/example to the community today are as follows: I have ...
-
Notice to purge data Closed
Hello - Any information or help will be appreciated. Is there a formula that can alert data entry personnel when a particular entry, needs to b...
-
Conditional Formatting Based on Data in another Cell Solved/Closed
Hello, I would appreciate any help you can offer on the following scenario. I tried conditional formatting, however, the columns in Row E either all...
-
Excel has file big size Solved/Closed
Hello, Hello, I have an .xls files I open with Excel 2007 every day. It is approximately 200 rows x 60 columns. Each day we create a copy of th...
-
Copy a cell in the same row as a matched cell on a sheet2 Closed
Hey, Let me try and explain this better. I need to match A2 with Sheet2!A:A, but the value I need is a cell on Sheet2 in the same row as the mat...
-
Move Rows of Spreadsheet to second spreadsheet Closed
Good Morning- I am keeping a spreadsheet of my projects. I want to keep the information for tracking and statistics later. Is there a way to move...
-
Macro to Copy Cells and Save multiple entries Closed
Hello, I am looking to create a macro (never done this before). Here is what I want it to do. 1) I have a master store name excel file (for exampl...
-
Conditional Formating: formula cell text change color Solved/Closed
Hello, How do I get Text in a Cell to Change from Black to White, based on data? The cell already contains a formula to extract data from elsew...
-
Colour in spreadsheets that are formulated Closed
Hello, I would like to know how to do the following on excel Same sheet with the amount of calls taken in number form goes into a cell then the ...
-
How to highlight the extra data in column Closed
Hello, I want to get the extra data in a column when compared to other column. For Ex: If ColumnA has following data 1 2 2 3 5 & column B...
-
Transfer between excel worksheets Closed
Hello, I would like to be able to transfer an entire row of attendance of students when it hits zero for attendance to another sheet or at the bot...
-
Correlation with complex Arrays Closed
Hello, I understand how to do a basic correlation. But, if I have thousands of student data and want to run correlations of student test scores i...
-
Automatically transferring rows of data between sheets Closed
Hello, I am creating an excel spreadsheet that will be used to keep track of my organization's board member and supporter attendance at events. I ...
-
date format *dd/mm/yyyy and dd/mm/yyyy Closed
LS, Hello, Please help me with the following question; What is the difference between the format dd/mm/yyyy and *dd/mm/yyyy when uploading dates an...
-
Conditional Formatting when a cell says "NO" Solved/Closed
Hello, I need your expertise in conditional formatting. I have a worksheet that where i have hidden a column ("J") with just Yes and No on it. W...
-
If a cell has a certain value after certain date, color the row Solved/Closed
Hello, I'm working with deadlines, and projects need to progress from one stage to another by specific dates. I have 3 deadlines: A: Create BR...
-
Matching 2 values from one spreadsheet Solved/Closed
Hello, I have 2 spreadsheets.. first has 3 columns id, date, time value second volume with id header across of date would like to populat...
-
Copying a range of data between 2 values Closed
Hello, Please could someone assist. I have a workbook with 97 sheets and I am wanting to create a macro that can copy a certain range of data bet...
-
Help please need formula Closed
Hello, I need for anything in column J that says complete to be moved to another sheet. How do I do that ?
-
How to count how many times a number appears in a spreadsheet? Solved/Closed
Hey~ I need to count the number of times a number appears in a spreadsheet. For example, how many times the number 1 appears in an entire spreadshe...
-
Conditional formatting from other spreadsheet Closed
Hello, Every day I update my excel spreadsheet based on customer demand. My boss uses a separate spreadsheet that pulls from mine. He wants to be ...
-
excel formula Closed
I need to generate a number list of 1-20000. is there any method?
-
Automatically copy data from one sheet to another Closed
I have read numerous articles about this and none have really solved my issue. I decided to post my own specific question. I have an excel workboo...
-
Removing false statement Closed
Hello, I would like to remove a FALSE statement, want it to show nothing. My formula is as follow =IF(A23=1,G23,IF(A23=2,G23,IF(A23=3,G23,IF(A23...
-
send email when a cell changed in excel Closed
Hello, hi guys, straight off, im stupid, extremely stupid so if you can help me please keep it simple as im barely technical at all :) anyways, im...
-
calculate to distance between two addresses on google maps excel Closed
Hello Friends, please help me if you can. what im trying to do is, i need to calculate the distance between two addresses on google maps and want t...
-
Creating multiple lists from one master data table Closed
Hello, I am trying to create a master data tab where expenses will get coded. I need each subsequent tab to be for a specific account and that ta...
-
How do I extract specific data from a cell in excel? Closed
Hello, what function would I use to extract just the city name from the cells below?...thanks! 6211 E Holmes Rd ,, ,Memphis, TN 381418310, U.S.A. ...
-
Conditional Formatting Based on Data in Another Call Closed
I'm a new member and I hope my question is clear. I need to change the background field color of cells in a column based on a value in a different fi...
-
Change color of text or cell if the value entered is same Closed
Hi! Can someone please share me how to change font or cell color if a value entered in a cell is already selected before. Ex. I wanted the font or...
-
comparing the two names respective of Upper & Lowercases letters Solved/Closed
Hello, here am trying to know something about the compare of 2 names in excel below is my format Http:CCM_net_C2E http:cCM_Net_c2E i have ...