Excel Forum
-
Macro - Create new sheet and generate information from Summary [Closed]
Hi all, Just wondering if someone can assist, I need to create a spreadsheet that has a running list of service calls (Summary) then once a line is...
-
VBA Macros Help [Closed]
Hello, I have a need to create a macro that is beyond my knowledge. I recently started trying to learn how to write simple macros in order to simp...
-
Multi Copying Excel 2013 [Closed]
Evening All I looking to copy the same lines of excel * so many times depending on number in a column. So anything input in A2,B2,C2,D2 is cop...
-
Help needed to compare excel worksheets. [Closed]
Hello, I have an Excel worksheet that contains a list of part numbers that I stock. I also have other worksheets that contain lists of parts that ...
-
Middle name extraction [Closed]
Hi, I need to extract middle name from full name. for some case its working but in those names without middle name, it throws #VALUE! error. also ...
-
Formatting whilst using letters and numbers [Closed]
I would like to conditionally format a spreadsheet based on grade progression, where the grade contains both a letter and number. The grades are n...
-
Conditional format make a row a color based on another cell [Closed]
Hi, I have a large spreadsheet with many rows and columns. I want to color a row green when we have been paid on that line. There is a column ...
-
How to insert columns until a cell condition is met [Closed]
Hi everyone. I'm not very good in macro and hope that anyone could give me some pointers. I have a worksheet (ie. Project A) whereby it contains he...
-
Paste data from specified cells to another when just typing comp [Closed]
Hello, Hello, I am trying to use macros to copy data from several cells into different cells in another sheet. My data is consisting of Organizati...
-
Macro to get random samples based on condition [Closed]
How to create a macro which picks random 200 rows from a excel file which has huge data. Each column containing both empty and valued data.
-
If cell contains a word from a word bank, then return value [Closed]
Hello, I need to be able to read a cell and see if it has any of the following word: John Jane Jake Jill Jack ect. Then return True on an...
-
Find the net elapsed time of a task [Closed]
Hello, I need to calculate the effective time taken by a task. I have the start date&time and end date&time of the task. Both the times are mai...
-
Macro-not refering correctly [Closed]
Hello, Iam very new to macro, i have written a code, that should work in sheet 6, but it always by defualt goes to sheet 1.Please find code below: ...
-
finding percentages [Closed]
Hello, I'm not sure if i'm asking my question in the right place or not. I need to find percentage of attendance for a period of time. I have...
-
Cell referrence [Closed]
Hello, How can we referrence a particular cell value in date formate in another cell which has a multiple number? Thanks
-
Lookup 2 cell headers one one sheet to find answer on another [Closed]
Hello, I am trying to lookup the employee name and week # included on sheet A on sheet B in order to find the % of utilization during that week. ...
-
Need only date from text [Closed]
Hello, how to get only date when a cell contains text. EX: MON 12/20/1968 12:30 . I want only the date 12/20/1968
-
Populating many sheets from one [Closed]
Issue: I'm working on a Google Excel doc which is being populated by entries on a Google form. Each row on the sheet relates to one form entry. ...
-
Get value from cell to other sheet based on condtion [Closed]
Hello, i have sheet with lot of data . i want to get some value of my sheet to other sheet in excel . for ex: Cell A | Cell B ==============AB ...
-
Excel function [Closed]
Hello, I need to auto populate the text in column A into another sheet if the adjacent cell in column B is a certain number. Configuration: Wi...
-
Issue in Excel [Closed]
Hello, i am unable to change the date format in excel... actually it show 42625 but while "F2: 9/12/2016 can you please help me to resolve the iss...
-
If text, return a date [Closed]
Hello, Having difficulty here. I have a monthly table (Jan - Dec) with varying text starting is varying months. I want to highlight this arr...
-
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...
Subscribe To Our Newsletter!
