Excel Forum
-
Dealing with 'Today()' formula in Excel VBA code Solved/Closed
Hi Everyone, I have this VBA code in a Excel sheet (specifically in the Module) which does the following: - finds the empty cell in range "B:B" -...
-
Macro needed to delete rows with certain condition. Closed
Hi, I have about 169,000 lines of items to go through and I'm trying to figure out a macro to delete every row that contains the word "Discontinue...
-
Excel > Macro for Defined Range Dates Solved/Closed
Hello, I've a question that I have starting date in Column "E3" Sheet 1 and ending date in Column "F3" Sheet 1. I want a macro that insert dates i...
-
Macro or VB code Help on Moving data from one sheet to another Closed
Hello, Would request you to please help on the following query I have. I have an Input sheet which has data entered in Column A to F like name, emp ...
-
Find second empty cell/row and start pasting from it Closed
I've already did a lot of research and couldn't find a solution. I'm trying to find the second empty cell/row (or other especified cell) in a column a...
-
Excel place a vaue in a cell if a number is in a certain range Closed
I need to setup ranges and place a number associated with-in that range. 150 300 450 600 750 900 This data is from column M. I need to b...
-
Formula compare two different cells containing the scores of tes Closed
Hello, I am trying to create a formula that will compare two different cells containing the scores of two tests. A student can only get PASS remark ...
-
Macro or VB Code Closed
Hi, Input sheet will have data entered in Column A to F like name, emp id, date etc and I need this data to move in specific cells of a pre formatted...
-
static dates Closed
Hello, I'm new to the abilities of excel and would appreciate any help. I'm trying to create a worksheet where when any data is entered in column A ...
-
Referencing like numbers with different extensions Closed
I'm not sure how to ask this, but I have multiple workbooks sent to me (new job-set up by someone else) with one of the sheets that I am to use in eac...
-
How to copy data based on criteria met Solved/Closed
Help! I am totally stuck and this is probably a very simple fix. I have two sheets "Priority Accounts" and "ACN Dashboard". I need to move data i...
-
Transferring data from one workbook to another Closed
I want to copy data from one work book to another. I have got a data which will be entered by the user on their excel sheet in the specified format...
-
Sum total numbers of the same date Closed
I have a column with various birthdates 1953, 1983, etc. In the column there may be 10 1953's and 30 1983's. how do I get excel to sum up all the ce...
-
Excel formula Closed
how to convert no in words. pls give me formula ex. 132507 Ans - one lac thirty two thousand five hundred & seven
-
SUM invoice number and invoice amount Closed
I am looking to sum up multiple rows containing currency, while disregarding the text. I want to take the "amount" and subtract the multiple ...
-
stuck Closed
Hello, I'm new to excel's advanced abilities. Is there a way to transfer the total of column E in sheet 1 to cell C3 in sheet 2? Configuratio...
-
Excel 2010 VBA Date Formula Solved/Closed
Hi, I am trying to get a formula setup so when you click on a cell in excel it automatically enters the date. I am using the formula below which wo...
-
Create a Sales by Week Combined Report Closed
Hi I want to create a report where I but in sales a use a Macro to insert a date and then insert all of the data in the worksheet into a seperate w...
-
Copy values in row to columns in spaces Solved/Closed
Hello, I am a beginner in VBA, and would mcuh appreciate some guidance on transposing data in a row to a column via VBA. My row data is as foll...
-
Excel report Closed
Hello, I create a seller report Worksheet 1--- I named it as Price list ... is a Data for my seller report that I set a code, name, points and ...
-
Copying data from one data sheet to another automatically excel Closed
Dear Excel Gurus, What I want excel to do is, if a name put in a certain category on sheet one, then it automatically get copied into another sheet w...
-
Adding comment to a Pivot Table using VBA Closed
I have a requirement to put comment in a paticular pivot table column . The user can insert column or delete column ,the comment should dynamically p...
-
Formula to perform range of sums based on range of words Closed
HI I am trying to find a formula that will basically: Check B2 to see if it contains the word "Fortnight" or "Month" or "Annual" and then "equal th...
-
Compare multiple spreadsheets + conditional pivot formatting Closed
I have a list of 200 locations that are looking to renew their internet contract. I am asking 30 different vendors to provide their best available pri...
-
Tranferring Data from one spreadt to another Closed
How do I transfer info, including the result of a formula and keep them updated from one spread sheet to another
-
Conditional Formatting Solved/Closed
Suppose I have date in Column A (from A1 to A100) and in Column B (from B1 to B100), Both data are numerical. If the data in Column A is greater than...
-
Movind data from one cell to another via a Macro Closed
Hello all-- I am in need of someone's valued assistance. Here's the story: I have an excel spreadsheet that contains address data in Cell B6 & B...
-
REMOVING " FALSE " VALUE IN "IF&quo Closed
Hello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(C13="",IF((K13>="06:00"+0)*(K13="...
-
Excel 2010 code that clears content of a cell on open Closed
Hi I am looking for code that clears content of a cell based on a value when the workbook opens. I have several sheets in the workbook with varied...
-
Conditional formating of row based on other cells Closed
Hello, I am trying to format cells A7-E7 based on the relationship between C6 and C5. Ideally they would be coloured on a scale between green and y...
-
Specific data from one worbook to another (Excel 2010). Solved/Closed
Hello there, I have two workbooks, one is an accounting spread sheet (named Cash Book) and the other has an Invoice Template (sheet 1) and Invoice...
-
If then formula using a date Closed
Hi, I'm trying to create a formula where if the date falls on or after 08/01/2012 the value returned is .0464 and if its before 08/01/2012 the value r...
-
excel 2007 custom filter problem Solved/Closed
Hello, I have been using Excel 2003 to sort phone numbers easily, using the custom filter and 'begins with' for example on numbers starting with 123. ...
-
Macro to Insert Multiple Images to Multiple Sheet of a Excel Closed
Hello Everyone, Greetings to All. I have some Issues in the below Macro. My intention is to Copy/Insert the multiple Images in a folder that I se...
-
Multiple columns using countifs Closed
I have a column such as a1 --- 'Vendor' ----> (Win/Loss) column N ...
-
VBA/Formulas for Repeating Values by Cell Value, w/Offset Closed
Hello, I have a pretty complex little thing going on, but I'm having trouble getting through the next part. Using VBA, two lists are generated ...
-
Making date appear on master copy Closed
Could anyone help with a formula for the date to appear on my Master copy of Items sold and purchased. i.e .A. .B. ...
-
Comparing Excel Columns - Help ASAP Please! Closed
Hello, I need help, please! I have two worksheets (C & Q). Each worksheet contains four columns, each column has different information(A=Date, B=Mis...
-
run VBA automatically when criteria is met Closed
I want to be able to run a macro automatically when criteria is met.. If any cell in column A is change to "re-let" run "rowformat" macro can an...
-
time calculation Solved/Closed
Hello, dear all please I need a help for formula to calculate the duration ( hours ) between two dates for example : A1 ---> 1-8-2014 1...
-
Macro that copies certain cells Closed
Hello All , I need a Macro that copies certain cells , from other workbooks in a folder . it should open the first workbook, copy 3 cells , past...
-
Automatic update of date from one sheet to another Closed
Hi I need to make a form that will update any written information from one spreadsheet to another automatically. E.g. I have one work-folder wi...
-
How to compare 2 sheets in Excel Closed
Hi, Could you please let me know how to compare data in 2 work sheets. I have the data in sheet1 and sheet2. I need to test whether the data in t...
-
Conversion of multiple column into single column Closed
Hello, I have a date set in the following format 1 3 5 7 2 4 6 8 I want this in the format 1 2 3 4 5 6 7 8 Please help m...
-
4 conditional formats Closed
I am attempting to add 4 conditional formats; First in red the 'cancel' - already done Secondly all things that complete on today's date in blue - d...
-
copy data skipping blank cell Closed
Hi, 1. How can i copy my my excel sheet1 (range B2:BJ800) data into sheet 2 skipping blanks cells. All want all data should be on sheet 2, colum...
-
Copying cells Closed
My question is similar to those above. We have rental properties. When a guest reserves I enter the data in one sheet (let's call it Sheet 2) that I...
-
Duplicating Macro Closed
Hi I currently have the below macro to duplicate rows for me but I want it to show the data in 2 columns instead of nderneath each other. EG OV...
-
VBA to copy and paste between workbooks Closed
I need a VBA to copy selected cells and then paste them into a pre-existing workbook. So it will need to open that workbook and then paste. For ex...
-
How to convert number into text in excel Closed
Hello, Thanks for the nice solution. I have a problem and that's what should I do if the number is bigger than 999,999,999? Configuration: Wi...
