Excel Forum
-
Excel Dates [Closed]
Hello, so how would july 7 1999 be written Configuration: Windows 7 / Chrome 53.0.2785.116
-
Name of Workbook, & howm many Number of Row Copied write on Cell [Closed]
Hi all, Can anyone please help me below i have added three more column H ,I and J In H Column i would like to give Workbook name which i want to co...
-
excel 2010 doubt [Closed]
Hello, i have doubt in excel 2010 need to segregate the data after certain limits. Eg: fdkfkpfokdsl;kfdfkfdpifdflkd-k12383433326-05-2016 Descri...
-
Excel VBA - Change cell color based on value smaller or biger [Closed]
Hi. I found some similar answers but i have no idea of VB and so i thought i could ask if someone can write this code for me... :) What i need is ...
-
Pivot Table [Closed]
Hi Users In Pivot Table Show details I want when i click on show details the Sheet which is created should have the name of the Row Header and c...
-
excel vba macro to Find word within cell and put value in adjace [Closed]
excel vba macro to Find word within cell and put value in adjacent cell
-
Conditional formatting based on specific expiration date [Closed]
Hello, I have a spreadsheet that tracks training my employees take. The cells include the dates (mm/dd/yyyy) that the courses were taken. Most of ...
-
Search then validate given values against given sheet. [Closed]
I have two worksheets. One sheet is called "Valid" and contains values in the following cells: A1= 1234 A2= 123 A3= 12345 A4=123456 The other...
-
copying values from one sheet to another with condition [Closed]
Hello, how to copy a values from row a to h into another sheet with transposing them into columns Configuration: Windows 7 / Chrome 53.0.2785.116
-
Copy and insert n rows [Closed]
Hello, I want to insert N rows between two rows(Data is already present in those two rows) and after inserting I have to copy the data from first ...
-
excel save button [Closed]
I would like to create a save button that saves a copy of my spread sheet to a folder on my desk top, the spread sheet would be named by the contents ...
-
Formula Question: "IF" function with date [Solved/Closed]
I am attempting to create a formula that will enter "Yes" into cell P1 if: the date in Cell E1 is before 07/31/16 AND the date in cell B1 is after 07/...
-
Copy a row of data which is based on a value, in Excel, not VB [Closed]
Hello, I have a worksheet which has current data listed by Item numbers, description, quantity, plan, paid, amount, unit price. I would like to cr...
-
Highlight cells with Text that match data validation menu [Solved/Closed]
I see several similar questions on the forum but not quite the same and the answers don't seem to extend to my situation. I have an Excel sheet tha...
-
Change cell colour based on other cells text [Closed]
Hello, I really need help on this one as I can't work it out. I need to change the colour of a cell if that cell and the previous 12 cells do not c...
-
Average Labor Burn Help! [Closed]
Hello, I am trying to do a sort of a burn. I need the cell value to be copied linearly across an x amount of rows, and the number or rows that it ne...
-
Conditional formatting on a sheet to grey out "Closed" Actions [Closed]
Hello, I'm trying to turn the rows in a spreadsheet grey when an action is closed and i've looked at previous responses but when I try them on my ...
-
Macro needed to copy entire row from sheet1 to sheet2 [Closed]
Hi, Could someone please help me with my Excel problem. The problem is How to copy few columns of a row(s) from one sheet to another that contains ...
-
Keep Drop Down/ Data Validation with Macro [Closed]
Hello, I searched around a lot and could not find an answer to this: I need to replace values in a cell with a macro while keeping the "Data Valida...
-
formula to copy cells that meet condition [Closed]
Hello, I have 5 sheets of data and columns D-G on those sheets are formatted with a drop down menu and color fill based on the selection. I would...
-
If Then Formula [Closed]
Hello, I need to count radios. When someone checks out a radio I want Excel to add up how many radios are out and how many are left. I added data va...
-
Repeating rows contents for a set number of user defined rows [Closed]
Column A Column B Product number Number of Sizes 1234 4 I would like to see the product number r...
-
Macro to insert rows with formula [Closed]
Hello, I need help. :( I would like to create a macro to automatically insert lines at the bottom of all my filled in row. After the lines are i...
-
Command Button to Move Data from One Sheet to Another [Closed]
Hello, I have a report with a data sheet and a data removed sheet. The data sheet is from column A:AC. In column Q I have different statuses tha...
-
Macro to copy list of values to another sheet , 13 times each [Closed]
Hello community, I need to copy list oif 1400 values from one sheet to another. Each value has to be copied 13 times. Can anyone advise on macro? ...
-
Macro to copy list of values from one sheet to another [Closed]
Hello, I need to copy list oif 1400 values from one sheet to another. Each value has to be copied 13 times. Can anyone advise on macro?
-
Excel Formula [Closed]
I need to match two cell in two different sheet but it can be a like or similar. Like if Found something written on Cell B1 (Eg Hyderabad) in Secon...
-
Transfer info from sheet 1 to sheet 2 [Closed]
Hello, I have a multi page spread sheet. Sheet one is a log of names with columns for dates they attend meetings. Sheet two is a log of attendan...
-
Add selectable prefix to cell contents [Closed]
I have a list of numbers in rows: 1, 2, 3,...999 I need to create them as 1001, 1002, 1003...1999 OR 2001, 2002, 2003 etc Sample Code: Cells(1, 1...
-
formula to find out all the master ID's [Closed]
Hello, My first columns is a Master ID which is unique for every row. My 5th column is the item name where item name's do get repeated. I need a...
-
Copy Potential data from one sheet to another if condition met [Closed]
Hello all, thanks for taking the time to read this, I have a very specific formula request, or at least a request for direction on how to write/lea...
-
need to match two values and return another value [Closed]
I have two spreadsheets in which I need to match two values and return another value. So, in my case, if Column C and Row 24 match (in spreadsheet A) ...
-
VBA - Filling blanks across multiple Worksheets [Closed]
Hi, I currently have an excel file containing multiple worksheets. Rather than filling in blanks using the same value above is it possible to ente...
-
Create Excel Macro for Automailer [Closed]
hi i Have one excel book,in excel sheet 1 contains distributor name & their E mail address,and sheet 2 contains some large amount of data of resep...
-
drop down list formula [Closed]
Hi, I am fighting to find the right solution for the following: I have in Column A a drop down list with two variables. -When they choose the f...
-
VBA - Filling in blanks across multple worksheets [Closed]
Hi, I currently have an excel file containing multiple worksheets. Rather than filling in blanks using the same value above is it possible to enter...
-
Compare data and summarize on seperate sheet [Closed]
Hello, Each month I download a 1,000+ line of Part Numbers with inventory qty and value to an excel tab. I want to compare the part numbers to se...
-
Need to create a macro [Closed]
Hello, I am looking to create a macro that will take only newly entered data from column A and column B on two worksheets (Pipeline - PM and Pipelin...
-
Search/Transfer Patient Data [Closed]
Hello, If anyone could help me, it would be greatly appreciated. Ok I have a spreadsheet with different patient names. If they are inpatient then ...
-
Excel - Macro to copy data from one workbook to another [Closed]
I need to copy data from one workbook and append the content to another workbook (WB). Ex: WB1 (source) has data in column A B C D E WB2 (targ...
-
Macros [Closed]
Hi, I'm new to macros and have only a little experience in programming. My question is, how can I get Excel to take inputs from two separate cel...
-
if then formula question [Closed]
Hello, If you have a value in cell a that equal 42:15 (42 hrs and 15 min) and in another cell you want it to look at that cell, determine if the hou...
-
pop up reminder vba [Closed]
hello everyone, i have very little knowledge about excel vba, actually i am making an excel file. i want it have pop...
-
Excel templates to PDF [Closed]
Hello, I am delighted to use the forum for the first time. I encounter an issue with my excel vba function. Not being a coder, I went online l...
-
validation code [Closed]
Hello, Why can't I get a validation code? Configuration: iPhone / Safari 4.0
-
format a group of cell by referring to a series of number [Closed]
Dear Sir, How to format a group of cell by referring to a series of number with different color. The color will change accordingly when the number ...
-
cut and paste a range of cells if two cells are duplicates [Closed]
I have a spreadsheet of documents that are in revision along with their status and other criteria that change daily. Row B contains the individual do...
-
Conditional formatting using dates [Closed]
Hi, Can anyone help please? I have: a column (E) of cells each containing options from a dropdown list named "MINOR" "MAJOR" "CRITICAL" ...
-
Another copy from Master to specific sheets [Closed]
Hello everyone, First post here and I am not, by any means, an excel expert (my husband thinks he is, which is why I'm here, lol). So here is my qu...
-
Macro for looping charting data keyed from two columns [Closed]
Hello and thank you anyone for reading this. I have a quandary that is beyond my VB skills and am looking for any help possible. I need to find a ...
Subscribe To Our Newsletter!
DON'T MISS
- How to Fix a Blurry Snapchat Video
- How to Create a Gmail Account
- How to Upload High Quality Photos to Instagram
- How to Get Free Diamonds in Free Fire
- Computer Boots to Black Screen
- How to Disabled Write Protection on a USB
- How to Install a VPN
- How to Recover Your Yahoo Account
- How to Get More Followers on Instagram
- Facebook Code Not Received
- How to Recover a Disabled Facebook Account