Excel Forum
-
VBA Code Not working when modified [Closed]
Hello! I have the following VBA Code on an Excel worksheet, which has been working fine up until today, when I modified it slightly (just changing ...
-
how to convert Date to word in excel [Solved/Closed]
how to convert Date to word in excel e.g. 05/01/1992 to change Five January, Ninteen Ninty two
-
Macro:- Deleting rows on condition for selected no of col. [Closed]
Hi. I have an excel for which i require to delete rows if there is "n" found in the row. But i want this row to get deleted for only a particular n...
-
Chg background color of any cell in range based on another cell [Closed]
Hello, I am trying to maintain a spreadsheet of races and personal bests for runners. My runners are in rows. The races and Mile Split times are...
-
Automatically transfer data from one sheet to another [Solved/Closed]
Hello, I have a workbook with 2 worksheets. Sheet 1 has about 400 line items. I would like to be able to select certain line items on Sheet 1 and ...
-
Calculate Total Total Hours Per Client [Solved/Closed]
Hi, I have a spreadsheet in which employyees time are entered on a daily basis along with the client they worked for. The spreadsheet calculates ...
-
How to change row color based on percentage?? [Closed]
Hello, Starting in cell "AB10" I have a value in percentage, if the percentage is below 20% I want the entire row to be yellow fill, if below 10% ...
-
Excel if range of cell contain a text put a cell value in [Closed]
Hi All, How do I put a cell value into a cell when the range of cell contain a specfic text. For example, in the sample below, I want to put the ...
-
Excel - Copying data from multiple files into a single workbook [Closed]
I am trying to find someone to help me write a VBA code that will search a folder with hundreds of .xls and .xlsx files and copy rows of data to a fre...
-
Building a reporting tool [Closed]
Hi Guys, This is my first time on this forum but it won't be my last. I am pretty functional with excel but lack VBA/macro skills but I am in the p...
-
VBA Code stopped working when modified [Closed]
Hello! I have the following VBA Code on an Excel worksheet, which has been working fine up until today, when I modified it slightly (just changing ...
-
Excel graph help [Closed]
Hi, I am trying to create a graph to show overlapping employee shifts but I am not sure how to go about doing it. I have the following employees...
-
Enter current date and time with SHORTEST CUT [Closed]
Hi, I'm using a tracking sheet for incoming couriers everyday, and would like to log each item as they come with current date and time. I've been u...
-
Convert values in 1 cell to rows [Closed]
Hello, I have an excel in which there are multiple values in 1 cell separated with comma. i want all the values in cell to be converted in to d...
-
How to count date cells for monday of this week [Solved/Closed]
Hello, I would like to count the number of cells with date = to MONDAY of this current week and also MONDAY of the following week within a defined...
-
xlsm vs xlsb [Closed]
Hello everyone, I've been reading up on the two different file formats and discovered a large variance in opinions. XLSB, being binary, apparently ...
-
Excel Help: IF function using OR, how to make False disappear! [Closed]
So I'm writing an excel formula based on Award placings in a race using the IF and OR function. I have the formula correct but I don't want anything t...
-
Copy a row and paste it down 119 times [Closed]
Hello, I am using Mac Excel 2011 and I am quite new to Excel Marco. For the purposes of organizing research data, I need help with creating VBA c...
-
add multiple if statements in one cell? [Closed]
Here is my current formula: =IF($R2="KM",$O2*$S2,IF($T2="KM",$O2*$U2,IF($V2="KM",$O2*$W2,IF($X2="KM",$O2*$Y2)))) what that does is only gives me t...
-
Auto generate the seller sales report [Solved/Closed]
Hi! I create a sales report and I set up total 6 worksheet Worksheet 1 I named it Price list ... is a Data for my sales report. and I set a co...
-
Separate numbers in different columns by a formula [Closed]
Hello, I want to separate numbers in different columns by formula. For example: in Cell (A1) having number 106,504.00 separate in different cells...
-
Formula to increment date by seven days. [Solved/Closed]
Hello Everyone, In a work sheet, I have an invoice date (say column A) and a due date (say column H) with the due date being seven days after the ...
-
Automatically transfering rows from one sheet to another [Solved/Closed]
Hi, I was wondering if anyone could help. I've created a spreadsheet to track all contracts complied within our department. I have a "Contract Sta...
-
IF function with Date addition [Solved/Closed]
Hello, I'm having trouble finding an answer as to how I can add 5 more days in my condition. I have 4 columns: one for an Order date (A2)...
-
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...
Subscribe To Our Newsletter!
DON'T MISS
- How to Get Free Diamonds in Free Fire
- Facebook Code Not Received
- How to Install a VPN
- How to Upload High Quality Photos to Instagram
- How to Recover Your Yahoo Account
- How to Fix a Blurry Snapchat Video
- How to Disabled Write Protection on a USB
- Computer Boots to Black Screen
- How to Recover a Disabled Facebook Account
- How to Get More Followers on Instagram
- How to Create a Gmail Account