The discussions
Transfer data and then apply formula
SolvedHello, I have a rather large spreadsheet which records the data from a number of different branches on each separate worksheet (labelled as "branche...
Macro to copy/paste specific range every 3 rows
SolvedHello, I am beginner in VBA and now have an Excel sheet with about 4000 rows, where I could need a macro. I already recorded a macro for the fi...
Need urgently to find a macro in excel report across sheets
SolvedHi, Anyone a solution? I need a macro that will do the following: 1. Search for a word, a number, ... across all the worksheets in the workbo...
Error trying to populate new worksheet using macro
SolvedHey everyone, I've been working on a macro to create a new worksheet based on the information entered into a column of a "data" worksheet which pop...
Add string only if a text is present in a cell
SolvedHello, i have this string =CONCATENATE(MID(B5;1;1);".") i use to have the initial of a name like this: from "Name" to "N." but some fields have no...
Copy cell from another sheet where cell is value...?
SolvedHi, Is it possible to copy a cell from sheet 1 to sheet 2 where (for instance) sheet 2 A1 is same value as a cell in sheet 1? What I have is: sh...
Macro for filling data from specific cell to another
SolvedHi all, i need help with creating macro to fill data from specific cells in column to another specific blank cells in other column. screen shot i...
Error: embedded excel spreadsheet
Solved/ClosedOccasionally I have an error with my embedded spreadsheets- it is "Microsoft Office Word can't start the application required to open this object. An...
Need value as per given criteria
SolvedHello, There is a range given on one column and on the other column there are points. Ex: 200 - 180. 10 points 179 - 160. 9.5 points 159...
If formula for a range almost works, except with blank cells
SolvedApologies if the title is too vague. I will if necessary rewrite it to comply with forum rules. I have posted this same question here: https://www....
Cannot browse - ftp ok, email ok, ping ok
SolvedHello, I have been following the thread from people with similar problems but mine is not fixed. This all happened yesterday when AVG falsely ident...
Date format
SolvedHello, i have a column in format like 14-02-14 and i want to change it like14-02-2014
If condition formula required
SolvedHello, Thank for the earlier reply. Please help in correcting the formula given below. condition is if a column is AB2>=1 it should reduce no. ...
Excel consolidation tab
SolvedHi all, I am wondering if it is possible to exclude one spreadsheet from being pulled into the master tab. I could name it Data. Can you advice? ...
If cell a1 has text then cell b2 has today's date
SolvedHello, I'm trying to find a formula that writes, If Cell A1 has text or any value, then B2 should show today's date and time. Can someone help m...
Excel - repeat rows a specified number of times
Solved/ClosedHello, I'm aware of the post here https://ccm.net/apps-sites/software/1603-how-to-repeat-rows-a-specified-number-of-times-on-excel/ But I wo...
How to repeat rows by x number of times
SolvedHi Does anybody know how I can repeat rows in a spreadsheet (or into another spreadsheet) by n number of times specified in the cell in that row ...
Rounding function
SolvedHello, Good day!! For the Excel rounding function normally is 4 down 5 up is it possible that rounding the digit as below request? 115.21...
Vba to refresh all pivot tables
SolvedHello, One of my worksheets has about 40 pivot tables. I know that there is a pivot table option to "refresh tables when opening file". But my raw ...
Macro to add/remove rows based on highest # in group of cells
SolvedI am looking for a macro that will look at a predefined group of cells (say A1-A5) and create as many rows based off the highest one on another sheet....
Copy specific cells to separate worksheets upon 2 conditions
SolvedHello everyone, vcoolio has kindly written me a script to copy and paste specific cells from Sheet1 to Sheet2 if ONE condition is met (ie "Yes" is...
Copy certain cells when an option is selected
SolvedHello, Can anyone help me with a script to: Copy: cell A, Worksheet One to cell B, Worksheet Two; cell G, Worksheet One to cell D, Worksheet Tw...
Arrow key now working.
SolvedHi, When i use the arrow keys using excel, the columns & Rows are being highlighted. How to unlock this? Can you help me to solve this?
Date format
SolvedHello, I want to write date into following format like (25/05/2015) into 25 days 05 months 2015 year. Is it possible??? Thanks Configuration...
Help to insert a date using a macro in excel
SolvedHello, I have a spread sheet with four tabs. I have written a macro to copy the tabs and rename them but I need to be able change the date which u...
How to hide and unhide tabs according to cell criteria.
SolvedHello, I have an Invoice that has a Rent To Own Sheet and also an Order Form attached to it. On my the Order Form tab I have a data validation...
Excel vba format a range borders to crossed diagonal lines
SolvedHello, please help me to format a range of cells like if in a range a1:c10 if any cell eg: c1 contains a value c then format diagonal lines wit...
Conditional formatting: 3 range of numbers
SolvedHello, would like to seek advice from some of the experts here. I want to do conditional formatting from column O6-O21. If percentage is a...
Reformatting a date in excel
SolvedHello, I could really use your help with Excel. How can I change a date formatted like this...03/12/2004...to just reflect the month and year...0...
Get a percentage in microsoft excel
Solved/ClosedHello, I am trying to get 10% of a number in another cell. rather than doing it in my head, I was hoping someone would know the formula. If you do,...
How to use name range..please help to solve this issue..
SolvedHello, i have a excel work book which has few name ranges eg namerange1, namerange2, namerange3.. how i can display the resultant like if column e...
Exam layout help
SolvedHello, I want to display a classroom layout on sheet 2 using a list of names from sheet 1 I'm sure it's possible, I just don't know where to sta...
Conditional formatting cell if every cell contains "yes"
SolvedHello, I want to A2 (surname) and B2 (forename) to turn green if every cell in range C1:F1 equals "yes". At the moment it is highlighting A2 & B2 i...
Compare 2 sheets -> summary differences
SolvedFor an ongoing school project values of test subjects are changing over time. I would like to create a quick overview of these changes. Examples ...
Conditional formatting for a particular column
SolvedHello, I need to perform conditional formatting on a particular column, which should display the numbers entered into it, in 3 decimal format. ...
How to search for a value in a range if found run a procedure.
SolvedHello, I am trying to get my spread sheet to run a Macro I have that is working nicely (that copies the row and pastes it to another sheet in the ...
Finding a date (n30) in a date range b5:b30 and returning a3text
SolvedHello, Thank you in advance for helping me... I really appreciate it. I believe I need an =IF formula.... I have a column with different dates ...
Auto. copy a row of data onto another sheet using conditions
SolvedHello, I am new to VBA and I have two spreadsheets both in the same workbook. One sheet is full off information the other is a printable form t...
Macro to search for a word and put a code on the cell next to it
SolvedHello, I'd like to scan a column for a certain word ("TOTAL LINE") and put a code (e.g "a") on the cell next to it each time it finds it.In case tha...
Macro for blanks
SolvedHello, Would appreciate help! I have a spreadsheet which I run daily. The number of rows can change each time I run it (ie one day I have 5 rows; t...
Transfer data from one sheet to another automatically
SolvedHello, I would like to populate data on a spreadsheet based on data obtained from another. Is this possible? If so, how can I do this? Example: S...
What cell is my data coming from?
SolvedOh dear - back again ... :^( After you guys help again with VBA. I'm never going to volunteer to try script-writing again! (at least not without...
Transferring information from previous spreadsheet
SolvedHi everyone, I'm a junior doctor from Australia, and I'm trying to use excel to make my ward management a more efficient process! Everyday we get ...
Single quote - excel 2007
SolvedHi, Does anyone know what the single quotation mark ' means when entered at the beginning of a cell? I notice that the quotation mark does not ...
Conditional formatting based on expiration dates
SolvedHello, I am trying to figure out how to introduce conditional formatting to a range of cells with date values. I want each cell in the range to b...
Two criteria to check if a date in excel
SolvedDespite my best efforts going round in circles on a simple problem. Help gratefully accepted.... If say, Cell A1 can have two values - "In" or "Out" ...
Formula to add big number of day to date in excel sheet
SolvedDear Please advise me how I can creat formula in excel sheet to help me to calculate due payment day for LC. As example I want to add 120 or 180 day...
Using the last few characters on a different sheet
SolvedHi All, Me again - I HATE VBA! it is so simple that I get frutrated when I cant get a simple thing right. Im trying to write a VBA script that n...
Vlookup won't work
SolvedI am trying to set up a formula in Excel 2013 that says to look at what is in X11, find the title and explanation in a group of cells on another works...