The discussions
Vba single click to get current date
SolvedHello, I'm brand new to VBA and the code that bhargav posted on Feb 6, 2013 10:48AM worked perfectly to get current time in a range of cells with ...
Macro to create, name and fill new sheets based data set
Sorry, I realize this question gets asked all the time. What I'm looking for seems different enough that I will need some specific help. The post righ...
Moving view, not moving selection
Hi there :-) Is there a way to keep the selection, e.g. multiple cells, but move the view to the top of the sheet? Of course another way than scrol...
How do i get a value in a cell based on another cell
Hi, How can I get excel to fill in some information for me? I want the value in column A to be filled in based on the value in either column B ...
How to compare two excel sheets with varying data
SolvedHello, Before I start let me just say Thanks in advance. So I am looking for an ongoing updated answer. Every 3 months we receive a new price lis...
I need to copy the hyper link as well as the text in the followi
ClosedI am new to VBA, This code looks in one sheet and pastes it in a new sheet, but does not copy Hyper link, can this be done. Range(wsO.Cells(1, 1...
How to return to only one line for each mail
Every mail in outlook comes with 2 lines. to open mail I click oj the second (the one with closed envelope). To delete this mail I need to click twice...
Ranking sorting problem
Hello I would appreciate some help on the following formula problem. I have a game where some teams have wins, losses and draws. My problem arises wh...
Pdf into excel
I saved my excel file as x but it was automatically saved as a pdf. I am using windows 10. The pdf is microsoft edge. I need it back as excel. Please ...
Find serial number and input average value into adjacent cell
SolvedHello, I'm trying to find out if there is a way to do this. i have a list of 15k serial numbers. several of them repeat because the value vary. i ...
Vba code for duplicating excel workbook
Hi all! My company use delay logs where we record delays everyday for different customers. At the moment every morning we're having to manually ...
Formula that can automatically classify monthly expenses
Hello, i need a formula that can automatically classify monthly expenses. I want the amount to be transferred to the similar subhead automatically as ...
One million and two hundred thousand only
I have try edit vba code in Excel for spell cu1,200,000 = One million and two hundred thousand only change in to One million and Two San only. please...
Downloading
Hi, can yoy help me how to download excel or spreadsheet using open office. I need it for my job. Thank you very much
Copy the data of a row based on identifying the data in a cell
Hello, I have data in about 20 columns and 100 rows There are some blank cells in column "I" (about 20 blank cells totally in "I" column, at di...
Excels docs are opening as pdf
Hello, I am using windows 10. My excel documents are being saved as microsoft edge files. This is a nightmare. I need the excel docs. Please help ...
If function
Hello, How many times we can use IF function in single formula?
Make adobe the default to open the pdf attachments
Hello, My Word cannot open PDF files attached to emails, it gives me an error. When I right click on the file as suggested I do not get a properti...
Cell = yes or other text return value
SolvedHello, I'm using IF statements to return a value for the specifc answer supplied for the question and then adding up all the questions for the t...
Need to learn excel how
i need excelent in ms excel , how any ways ,suggestion or reference sites..i thank full to your help.
How to check % value in excel and macro using vbscript?
SolvedWant to check a cell with % percentage format matches the value in Vbscript code. Sub ChangeColor() Dim lRow Dim myVar lRow = Range("AC" & Row...
Formula to copy rows a set number of times
SolvedHello, I have a delivery manifest that shows the amount of products coming in, descriptions etc. that we use to produce barcode labels. Unfortunatel...
Vba copy data from a range and paste to empty column
Hello, I have a set of values in range P6:P15. At the end of each month, I would like to copy and paste the data from the current month column to ...
Automatically transfer excel row to a different sheet based
Hello, I have a spreadsheet for paid & unpaid invoices from our customers and would like to have the row automatically move once I mark it pa...
Vba using subroutines - help please
SolvedOk guys, I have a problem (well more than one, but Im not sure I should mention those on this forum!). Im in the process of writing an Excel macro ...
Sort type and size excel formula
Hello, can someone please help? I'm trying to write a formula that would sort Type and Size on the following spreadsheet which has the following: ...
Extracting matched observation and its corresponding row
Hello, I have excel sheet containing around 100K observations (rows). There is one column say "A" containing some IDs and each ID is having 10 par...
Can't change format of cell
Hello, Using Excel 2013. I have a document which consists of various combinations for padlocks in a format of 00-00-00 most come out correct...
Date format nightmare
Solvedsolved with this: Because it is not a date to excel. 1. Select the column in which there was date 2. Goto data and choose text to column 3....
Excel sum value...
SolvedDear I would like to know how to do the below mentioned formula I have tried but not resulted. Excel - Sum value in column when cells contains ...
Formula help
SolvedCan someone please help me with this formula =IF(G2="1",VSC410, IF(G2="2",VSC450, IF(G2="3",VSC470))) What i am trying to do is : if G2 has the...
Conditional formatting based on year
SolvedGuys, I come again cap in hand with another plea for help on a sort of finished project, but I want to make it better. I have some conditional f...
Extracting rows from excel
SolvedHi there, I have an excel sheet with a very large data. I want to extract different rows and write them in to different sheets of the same excel (or ...
Increment cell value based on change in value of another cell
Hello, Say I have a value of 100 in cell B3 and I need this value to increase/decrease based on the change in value of A2. How do I do that? For e...
Excel query
Hi I looking for a formula that will calculate an average order spend by day without having to do this manually(1, 2, 3 ). So for example it tak...
Blackberry
Hello, i cant open my blackberry mobile because i forget id or password Configuration: Windows 7 / Chrome 47.0.2526.111
Copy and paste multiple
Hi I'm looking for away to be able to copy a single cell from multiple sheets (tabs) for example cell a1 and list it's contents on a separate summ...
Auto populate record from one sheet to another
Hello, I'm working on a commissions spreadsheet for my company and would appreciate some assistance with a question I have. There is a separate ta...
Data link
Hello, I'm needing help please, I'm trying to figure out how to either: Link an Access database to an Excel Spreadsheet where it has a templ...
Free word processing software
Is there free office word proccessing software and how can I get it?
Conditionally format a cell so it turns a certain colour
I was wondering how to conditionally format a cell so it turns a certain colour when it goes past a certain date. Thanks
If, and question
Hello, I'm trying to work a formula that will change a given value in one based on dates going into several different cells. Example. If I pour a co...
Column to vlookup
SolvedI am trying to write a formula that will give me the value in a cell, it needs to come from two sources. I must be able to locate the column based on ...
If function with time duration
Hello, I dont understanding why this can't work : =IF((g2=timevalue("0:30"));"25) G2 has a time duration time unit in it which equals 0:30. ...
Disable a cell in excel using vb code
SolvedHello, I am looking for a VB code to disable a cell based on the value of another cell in excel. Example:- Need to disable Cell B1/C1/D1 based o...
Conditioning formula to convert "x" into another cells value
good morning, I have a spreadsheet I am trying to create for a chili cookoff, I am trying to find a way to type an "x"(or any text) in a box showin...
User friendly code for admission no
SolvedHello, I would like to request to Code for Admission No Range is started from B11 to B510 If user enter a123456789 or a-123456789 it always conv...
Days of the week conditions
Hello, I am trying to create a template for my work. I have a table sorted by dates but need to reference the day of the week that date falls on....
If one cell g4 has value 12345 then cell f4 will have....
SolvedI need help with a basic excel formula. Please :) If cell G4 equals 12345 then cell F4 equals USXX but also if cell G4 equals 54321 then cell F4 w...
Auto copy row from one sheet to another via info in first cell
SolvedHello everyone, hope you all had a great New Year. I am in the process of exporting a BOM out of Inventor and then opening it with Excel. Once I ha...
