Hello, so how would july 7 1999 be written Configuration: Windows 7 / Chrome 53.0.2785.116
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...
Hello, i have doubt in excel 2010 need to segregate the data after certain limits. Eg: fdkfkpfokdsl;kfdfkfdpifdflkd-k12383433326-05-2016 Descri...
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 ...
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 adjacent cell
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 ...
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...
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
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 ...
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 ...
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/...
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...
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...
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...
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...
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 ...
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 ...
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...
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...
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...
Column A Column B Product number Number of Sizes 1234 4 I would like to see the product number r...
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...
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...
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? ...
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?
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...
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...
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...
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...
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...
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) ...
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...
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...
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...
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...
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...
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...
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 ...
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...
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...
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...
hello everyone, i have very little knowledge about excel vba, actually i am making an excel file. i want it have pop...
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...
Hello, Why can't I get a validation code? Configuration: iPhone / Safari 4.0
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 ...
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...
Hi, Can anyone help please? I have: a column (E) of cells each containing options from a dropdown list named "MINOR" "MAJOR" "CRITICAL" ...
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...
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 ...
DON'T MISS