The discussions
Comparing data
I have two sheets with data, for example product name, quantities sold and price. All product names on sheet 1 may not be there on sheet 2. So what i ...
Two lists of names that are jumbled up
Hello, How are you all? I have two lists of names, one has all the names (A) e.g. Michael Luis Stevens, the other does not or the name is jumbl...
Excel vba to open a eula script when opening a spesific workbook
SolvedHi Everyone I am busy designing a training pack with formulas in a excel workbook using MS Excel 2013 and have it already password protected using vb...
Vba macro copy and paste loop help
I need to create a macro that allows me to copy and paste a set of formulas/values down a certain number of times. For example, if I had the following...
Conditional formatting
Hello, Can someone help in figuring out a formula. If in the spreadsheet I enter under the condition column "good" or "bad" I need the next column...
I need your help with macro's please
Hi there, I have been doing some reading up & watching YouTube tutorials regarding Macro's that will copy data from one sheet to another if certain c...
If value in column a exists between values in column b and c
Hello, Looking for assistance on the following: I want to know if value 302000000 (column A) exists between value range 382777400 (column B) and...
Copy all rows with specific name to new sheet
SolvedDear Friend, Am having a Excel Timesheet with following columns SITE - EMP NAME - EMP ID - EMP JOB TITLE - DATE - TIME IN -TIME OUT - TOTAL - NOR...
Vba to change cell colors and highlight rows
Here is what I have going on. I have a spread sheet, across the top are the dates of days that my crew works and the first column is everyone on the c...
Macro that will allow tab 1 's information to be copy to tab 2
SolvedHello, Please help. My Excel Workbook has two tabs. Tab 1 contains all project information such as project number, customer name, project name, co...
Transfer a row of data from one sheet to another same workbook
SolvedHello, I am trying to transfer a row of data from one sheet to another in the same workbook but my code is not working could anyone help me thanks...
Compare two cells in excel and if matches need to print its adja
Hello, I want to compare two cells in excel and if matches need to print its adjacent value in next column. for example: I need to compare colu...
Convert number to letters in excel
SolvedHello, I have to define the numbers to their associated letters and based on the combination of numbers the next cell should show the letters. ...
Convert date of birth into words
SolvedSir, Kindly help me in changing date of birth into words. Example:20.03.2001 as twenty march two thousand one
Macro copy paste from one to another based on cell value
Hello, I have two sheets. Phase I and Phase II. Phase I I have columns A-J. Im looking for a macro which would copy columns A-F and paste it to she...
Automatically moving data
SolvedHello, I have a master data sheet that one column in the sheet that represents a sub set of the data. When I add information to the master sheet, I ...
Moving data
Hello Peeps, I'm having some trouble with using a macro to copy some data from one sheet across multiple. I have a master sheet that contains train...
Find word within cell & put "value from a list" in adjacent
Hello, If cell A contains a short statement (e.g: 'supply of computers', 'supply of furniture', 'construction of water taps' and 'construction ...
Create macro to create worksheets based summary sheet
Hello, I have an extremely long list of inventory items by department number. What I want to do is create a individual worksheet for each departme...
Autofill and open worksheet
Hello, I am wanting to be able to search and open worksheets by typing the beginning of a worksheet. I have worksheets X,Y,Z and if I begin typi...
Search cell for multiple text strings, return each found value
Hello, I have a basic function to search a cell for a specific text string (in this case, the name of an application) and return a value to anoth...
Need vba help
Im pretty sure i will need VBA for this issue and I have no clue. I setting up an online store and I would like to track all my stock and transaction...
Due date alert from excel file when windows startup
Hi, I need clarification that we can create due date alert from an Excel file when windows start up. Is it possible. If yes, Please advice how to c...
How to create an text based spreadsheet
I have access to Excel 2010 in an MS Office Suites. What I am try to do is to create a spreadsheet where I can enter a designated code (i.e. A1, A2...
Location master file in excel
SolvedI have location master file in excel. 1) I have another file in A2 column there is a address like 422, Ashok Vihar, New Delhi, 2) i want to brin...
Create new excel file from existing excel file.
Hello, I want to create a command button in a existing excel file that will pop-open a new excel file. (it will be good if it ask me "Save as" for ...
If "yes" in a column copy other cells to the next tab.
Hi Guys, I have a sheet with participant names and a lot of other information about their attendance. What I am trying to do is to copy their name ...
Sales invoice in sheet1 and create summary table in sheet2
hi im working on sales/inventory worksheet. i made the sales invoices in sheet1, now i want all the details of sales invoice in sheet 2 to create ...
If statements
SolvedHello, I have a scenario working with a time sheet. So basically the way payments work is from 30 minutes to 5 hours is automatically 5 hours of w...
Date formatting
I would appreciate if someone can help me here. When I export transaction list from a Bank Account for example, the dates for some reason appear in d...
Auto update data between sheets
Hello, I have 3 sheets with data table all linked to sheet #4. how to set that every time a new data is entered on one of the 3 sheets it will ap...
Conditional formatting in excel 2010
Hello, In a celll that contains an if fumula which calculates if a cell is an "Actual" or Forecast" based on a drop down box selection, I would ...
Code to copy entire row into sheet two or three
Hello, I created an excel document with different rows. I would like the ability to transfer these rows to either sheet 2, 3 or 4 based on either ...
Counting names separately
Hello, I would like to request that how to count names separately if in any one columns contains more than one names. Such as it is given below: ...
Conditional format range if one cell contains certain text
Hello, I'm looking to use conditional formatting to make the cell next to a particular recurring word (for example, "new") highlighted. I have a s...
Creating macro to search two values and delete them
Hello, I´m new here. but I´ll try to do my best. I am looking for a macro where I can search in the column "I" all the values between two value...
Verifing-vin numbers
SolvedGood Afternoon, I have two Excel Worksheets, Mobile Equipment List, and USDOTALLBasics. Both contain the Vehicle Id Numbers. Is there a way to comp...
Dates from an if statement
Hello, I ve selected some dates via a simple if statement and can see the dates in the cell where I want them. But when I try to use them in anoth...
.xlsx, xls file
Hi, I am not able to open the MS Excel file i receive in xlsx or xls format.How can i open it ? Thanks, Manwendra
Weekly totals
Hello, I have a column of dates and a column of transactions. Often there are multiple transactions on the same day. How can I enter a formula in ...
To find a word in a sentence columnwise
Hello, I am trying to find a particular word in a set of sentences columnwise. For example cells A1:A100 has the sentences and cell B1:B20 has the...
If date exists (or any value) in b2, return value of 1 to c2
Hello, If for example there is a value of a date in column B (Row b2 or other) I need it to return a value of 1 in column C (C2 and corresponding)...
Using formula for conditional formatting
Hello, Excel 2013 I need to add an if formula that creates conditional formatting and I get the basics of it but my formula is not working It's ...
Formula that searches in a row for a cell/column that contains
SolvedHi. It would be greatly appreciated if someone could assist me with the following formula in excel: I would like a formula that searches in a ro...
Removing a returned value of false in excel
Hello, Here is my formula. Please tell me how I can eliminate the FALSE value for cells that don't fall within the date range (e.g. cells with dat...
Error in vba
SolvedHey, So I Have the following code: Sub GesamtlisteAenderung(ByVal Target As Range) Dim x As Integer If Intersect(Target, Columns("B:...
Automatically transfer data from one sheet to another
Hello, I have never done anything like this and i just watched a video that got me the first two correct columns in the second sheet but i am unable...
Extracting data from sheets added everyhour
is there a way to extract data from sheets i add? like if i have data from multiple hours but i put all the data in one book but in different hours is...
Replace function in macro
SolvedHello, I would like to request that in the range D11 to D510 if "-" or " -" or "- " this found then it would be replace with " ". Please do it ...
Securing a excel workbook
SolvedHey! I Need to save a Workbook strictly as a Template where the peolple at work can't screw it up. I'd like to have it so that they can open my...
