Excel Forum
-
dropdowns in excel [Closed]
There are multiple ways in which you can create a dropdown list in Excel. Data Validation Form Control (Combo Box) ActiveX Control (Combo Box) But...
-
Conditional formatting based on dates [Closed]
Massive long shot here.....I'm trying to conditionally format certain cells to black out after the end of a certain month. It is for a monthly time...
-
move completed data in sheet 2 [Closed]
Hello, I have raw data in sheet 1. I need to move completed data in sheet 2. I m using column H to update work status as "completed or pending". Pls...
-
Excel VBA - Color Code Column cells based on values [Closed]
Hi, Super new to VBA, and need to write code to evaluate the values in Column I, starting with I3 and going down a varying number of rows depending...
-
How do I change the format "YY/MM/DD" to show as "MM/DD/YY"? [Closed]
Hello, I have a spreadsheet that I need to convert the date fields from the format "YY/MM/DD" to read as "MM/DD/YY". For example, if the field c...
-
Need to write a macro to copy a row of information if true [Solved/Closed]
Hi, I have a workbook with several tabs and I want to first check if Column F on the first sheet contains 13 as the year (12/16/13 is the format) and...
-
VLookup [Closed]
Hello, I have a spreadsheet with column headings, Project Manager, Project Cost Engineer, and Project Schedule Representative. Once I key in th...
-
VBA cut/paste in another tab [Closed]
Dear all, I'm trying to copy in a different tab all rows that indicate in column [AN] a value less to or equal to 12. However, this column, as i...
-
Transfer Data from a sheet to another many sheets [Closed]
Hello, I am trying to transfer data from one sheet to many other sheets . For example , when I write data to a row , I woul...
-
every time copy and paste to master excel sheet one by one [Closed]
Good morning, Am working at Food Product Company in Quality Section . i received so many mails from depot Product complaint details in excel sheet...
-
Assistance with Excel macros [Closed]
Greetings all My company uses Excel to track inspections and maintenance of portable fire extinguishers and I'm trying to add some functionality to...
-
Automatic duplication of info to sheet 2 for ordering form [Closed]
Hello, Configuration: Windows 7 / Chrome 39.0.2171.95 I'd like to know if anyone on this board could help me or direct me to where I can fi...
-
Text label and value if value in other worksheet is > 0 [Closed]
can anyone help me with a formula for this. Text label and value, if value in other worksheet from 2 different cells is > 0, label based on witch c...
-
Conditional Formatting a row from a validation list [Closed]
Hello, OK, I am trying to apply a conditional format to a worksheet whereas I have a validation list in a column at the end of the row of data. Ba...
-
Excel-Macro to sumup data from multiple workbooks to Master xlsx [Closed]
Hi All, Can you please help me. Scenario: 1. There is a common template which has some tasks listed in columns against which the team members wil...
-
VBA help! [Closed]
Hello, I am absolutely a novice when it comes to macros and VBA and need some help. I have a workbook with 6 worksheets. The first work sheet ("Al...
-
Using a Macro to copy & Paste from one sheet to another. [Solved/Closed]
Hello, Hi Guy's I hope you can help, I am using two sheets. one is spread across different rows so when I click create list it copies everything ...
-
excel formula numbers to dates [Solved/Closed]
Hi, I need an excel formula for changing numbers to dates. It is part of the Julian Calendar but backwards and one extra number. Ex. 273143 is 9/...
-
how to use releative refrences in conditional formating?? [Solved/Closed]
the first picture is the formatting rule of C7 cell the second picture is the formatting rule of E7 cell which i copy from C7. as you c...
-
Transferring Data From A Excel Workbook to Another Automatically [Closed]
Hi There, I'm fairly new at macros and I would like to write a code that will help me transfer data from a workbook to another. I update Workbook 1...
-
Conditional formatting based on another cell [Solved/Closed]
Hello, this is what I want: EXAMPLE: B3= Arash if B6=1 then B3 goes red if B6=2 then B3 Goes yellow and if B6=3 then B3 goes green i want to...
-
Conditional formatting based on another cell [Solved/Closed]
i want to type a name in cell B3. and I want the cell's color change when I type 1,2 or 3 in B6 cell by using conditional formatting. is that possible...
-
Excel: Merge adjacent rows if they contain the same values [Closed]
Hello all, I am trying to speed up a task which I have do it manually with VBA: There is a table like below" Date;Name;ID;Text 20120...
-
color cell [Closed]
please help me how to apply colors in cell using with formula..
-
PROBLEM IN EXCL [Closed]
=IF(Y9="adgaon kh","channi",IF(Y9="ambasi","channi",IF(Y9="changefal","channi",IF(Y9="channi","channi",IF(Y9="charangaon","channi",IF(Y9="chatari","ch...
-
Converting Multiple Rows to One with Multiple Colums [Closed]
Hello everyone, Can anyone help me with converting the below example of data in Excel Many thanks in advance.
-
append row data from 1 sheet to the end of a matching cell row [Closed]
If columnA in sheet2 matches columnB in sheet1, append the data from the row in sheet2 to the end of the row in sheet1. Sheet1 may have multiple rows ...
-
help me to add particular cells [Solved/Closed]
Hello, i want to sum particular cells when a number consists in a cell eg:- =IF($B$81:$BH$81=7=TRUE,SUM($B$77:$BH$77),0) it calculates a...
-
Macros From Rows to Excel Files [Closed]
Hello Fellas I have a workbook in which I have a list of Clients with details in the columns (name A, phone B, direction C, ZP D, etc) and I need t...
-
Conditional Formatting [Closed]
Hello, I'm trying to create a table for a field trip. Essentially, I want the students name highlighted based on their homeroom teacher. There are...
-
Macro/command button help [Solved/Closed]
Hello, I am in need of some help here and would greatly appreciate it. Here is what I am trying to accomplish. I have a basic excel file with two s...
-
Copy info from one excel sheet to another sheet [Solved/Closed]
Hello, I am respectfully asking for assistance on an issue i am having trying to write a macro for a form that i am currently working on. I have ...
-
Avoiding excel cropping text when next cell contains formula [Closed]
Hello, If you have empty cells to the right, text from a cell will float over the columns following. However, if you have a formula placing "empty...
-
to check first letters of two columns are equal [Closed]
Hello, could you please tell me how to check whether first letters of two columns are equal
-
how to auto copy [Closed]
Hello, My workbook contains about 1000 sales entries on sheet 1 . Some customers paid in full, but some other don`t. I will put a * beside the cus...
-
What Type does it want? (VBA question) [Solved/Closed]
Hello, So I have a pull-down list in Excel 2003 that is an expanded version of this: 011 012 01T 111 If I type in the cell (rather than ...
-
comparing two columns [Closed]
I have two columns both of which contain list of names.i want to get the output as true if the names are somewhat similar eg dane john and dwayne john...
-
Auto Hide Rows & Columns [Closed]
Hello, i have a worksheet with many formulas in it. i use bellow code for auto hide rows and columns when a a cell in that column or row is 0 or e...
-
copy info from one excel sheet to another sheet [Closed]
I have sheet 1 that i call "FORM" that I enter information into. I would like to create a macro to copy the info that i put on the FORM onto sheet 2 "...
-
Excel Macro to Create a Workbook for Each Change in Column A [Closed]
Hello everyone. I love forums like this where the community helps one another and solve real life problems faced by real users. I would very much ...
-
fix the last date [Closed]
Hello, my target is 3900 but daily target is 50, how to fix last date for closing of my target. please define formula with examples Configurati...
-
Conditional formatting??? [Closed]
Hello, If I enter 1 in a particular cell, I want that cell and the next cell in the row changes to certain colour fill (ex. G5=1, then G5, H5)... ...
-
VBA programming, copy wks from one file to another [Closed]
Hi, I am struggling with the code to copy each sheet in workbook1 to workbook2) Dim NewWorkbook As Workbook Dim Wks As Worksheet Dim wb1 As Work...
-
Conditional Formatting to hide 00:00 in column [Solved/Closed]
Hello, I would be very grateful if there is somebody who could help me find the solution to what is most likely a simple problem. I don't have a grea...
-
coping & pasting data in first blank cell in same worksheet [Closed]
Hello, I would like the vba code for a macro ( using a form button) that copies data from cell:M1 to A13:A30 depending on which is the first blan...
-
Conditional Formatting based on Checkbox [Closed]
Hi, I've been trying to conditionally format a merged cell by what happens to a checkbox. If my checkbox is blank and the control cell in B16 is "...
-
help me on this formula to shorten [Solved/Closed]
Hello, i have 2 formulas tick mark automatically on worksheet.. please help me if further it can be shortened.. i want to know if J1 K1 L1 can sho...
-
conditional format problem [Closed]
I have 3 columns Column A start time (hh:mm) Column B finish time (hh:mm) Column C is total Time (hh:mm) where C is (24-A1)+B1 etc How can I hide the...
-
How to copy data from one spreadsheet to all others [Closed]
Please, does anyone have a macro to copy data from a specific range on a standard sheet (ideally with formatting) to all but one other sheet active in...
-
Copy data based upon cell value [Closed]
Hello, Need help on copying data from file1.xlsx into multiple .xlsx file based upon column G values. The file1.xlsx contains... Column F Column...
