Excel Forum
-
Excel Macro to insert a new row [Solved/Closed]
Hello, I would like to create a macro in excel to automatically insert a new blank row immediately after the last row of filled-in data and for th...
-
Excel Macro [Closed]
Hello, I have 24 cells(12 historical data and 12 forecast data) row-wise and they are not in continuous order. I need a macro code that would make...
-
adding files or rows of my selection excel [Closed]
Hello, The book must be able to, select automatically files or rows according to a title somewhere in the sheet. For example A ...
-
Sum of numbers using macro [Closed]
Hello, Please help me write a macro to sum the numbers in a column . Thanks ,
-
Macro to Insert a row below [Closed]
Hello, I want to insert a whole row below each found "input" in a coulumn. ie. A Time Elapsed 0:05 0:05 0:10 0:05 ... and ...
-
Help with If VBA Statement [Solved/Closed]
Hello, I have this code that i can not get to work all the way i get the error of "Too many local, nonstatic variables" i am new to this and all i...
-
Macro for Select next line [Closed]
Hello, I need help, i have macro in that file Column A already i have 10 lines of data. again i have to include few data for that how can i fine n...
-
Excel function or macros [Solved/Closed]
Hello, I have a table in which every number from 1 to 52 expresses a specified text For example 1 = Sofia 2 = London ... I n...
-
Browsers not working [Closed]
Hello, here is my hijackthis log, I am currently in safe mode. Please help, thanks. Logfile of Trend Micro HijackThis v2.0.2 Scan saved at 7:29:57...
-
Link column data to row cells - formula [Closed]
Hello, I am trying to copy data on one worksheet that is in a column to a separate worksheet that is in a row. Worksheet 1 B C O...
-
Create sheet base on the header [Closed]
Hi, Can some one help me? I have a data with 2 worksheet 1)Data source 2)Data with header I would like to know how can i match the header wit...
-
Macros [Solved/Closed]
Hi, I need a macro coding for the below scenario. In column D(Application) i have created a validation in which i have included the list of appl...
-
Macro to show nonzero data in dialog box [Closed]
Hello, i want to create a macro to show the data from the sheet in a dialog box. Let suppose i have a sheet where i record the rent information a...
-
excel formula [Closed]
Hello, okay, say i had six new customers and out of six i closed three on a sale. that is closing 50% of customers. so, if V12=6 AND X1...
-
Macro, Range Selection [Closed]
Hello, I have a macro that chooses dates from a field which is a general download from our information system. It then sorts the dates Ascending, a...
-
Date copy issue in excel [Closed]
Hello, I need to copy dates from a webpage, it is displayed as JUN 12,2010 00:31:26 and I need the same date in excel as 12/05/2010 00:31 I'm u...
-
Date wrong after converted in Excel [Closed]
Hello, I have data pulled from database to CSV file which can be opened with Excel. The date in the spreadsheet shows as "201003" in text format, an...
-
Excel Help with Percent calculations [Solved/Closed]
Hello, I use "=AVERAGE(B2:AR2)" to calculate percentages based on information from 40 sheets. Example, On one sheet that compiles the data from 40 she...
-
MS Excel problem [Closed]
Hello, Please help me to find the solution in MS Excel.. I have 2 sheets..Sheet 1 contains the Column B-list of mobile Nos and ColumnC - the users...
-
Excel formula [Closed]
Hello, I nee to remove formulae for calculating averages in cells; replace these with average value.
-
How to copy visible cells after filter in VB [Closed]
Hello Team , How to write a code in VB which will filter the visible cells after a autofilter has been applied .As my data range chnages with each ...
-
Select view in Excel [Closed]
Hello, I am using Excel as a source for fill-in templates. I would like to restrict the view of the worksheet to one page (fax cover sheet etc). Is ...
-
checking data in 2 columns and sending email [Closed]
Hello, I am trying to get excel to send an email with data based on 2 columns. I want it to look at column c and it the date is equal to or earli...
-
finding matching numbers in 2 excel columns [Closed]
Hello, I have 2 columns of numbers and I need a way to find the first instance that a number in column 2 is greater than or equal to a number in c...
-
VBA language for a range of cells [Solved/Closed]
Hello, I created a calendar cell pop-up and I wanted to include it in a range of cells. However I can't figure out how to include an entire range of c...
-
EXCEL IF statement with % [Closed]
Hello, Im trying to get a formula for the following statment: A1 is Within 20% of net sales, then give it a score of 5 A1 bt. 21-25% of net sale...
-
Compare multiple cells and return other value [Solved/Closed]
Hello, a problematic case, when comparing values in multiple cells (rows) in Excel. In a single cell , "A1" I would need an answer depending on...
-
EXCEL: List Cell Number if contains number [Closed]
Hello, I need help here. Have tried everything I can think of and still not getting the results I need. I need a formula that will list the na...
-
Problems with browser [Closed]
Hello, My daughter downloaded Lockdown Browser from her school website. Now everytime we try and open anything, including iexplorer, ms word opens. ...
-
Macro, search date, copy & paste values [Closed]
Hello, I am having problems writing a macro which will search for a date that is inputted at cell C1. IF the same date is mentioned in row 3 then co...
-
create a sheet [Closed]
Hello, there is a two sheet in excel one is data & second blank how to i creat a perfect database in second sheet which is not repeat in first s...
-
finding an excel solution [Closed]
Hello, Dear sir, I requeire answer for the below. Persone name Product name---Quantity sold RAJA LUX ...
-
Excel VBA ActiveWindow.SelectedSheets.PrintOu [Closed]
Configuration: Windows XP / Internet Explorer 6.0 When I use the following code in an excel vba module: PDFFile = "c:\test.pdf" Active...
-
Downloading details from mailbox to excel [Closed]
Hi, I want to download details from my outlook to excel. Can this be done using macros? Please assist.
-
open tabs from combo box excel [Closed]
Hi rizviza1, Maybe you remember me , a few days ago you help me with this code: Sub ComboBox_Change() Dim Target as String Target =...
-
excel conditional formatting [Closed]
Hi, I have the table having 8 Coloumns and abt 800 rows. I want to highlight the duplicate rows based on 4 columns. I gone through remove du...
-
Matching data in Excel [Closed]
Hello, I hope someone can help with an easy way to do this! I have a list of customer numbers in column A and I need to create a table showing ...
-
Comparing two columns of text, by row. [Closed]
Hello, I need to compare two columns of text data by row. All I want to identify is where C4 (last months rating of B), is not the same as D4 t...
-
Append last 3 columns of data if column B dup [Closed]
Hello, I've come close to making this work, but I can't quite get it right. I have a spreadsheet with customer acct # in column B-- we receive th...
-
Need Excel Percentage!! HELP [Solved/Closed]
Hello, I am having diffficulty writing a formula to calculate a percentage. I need to calculate 25% of $ 3,100 - I thought I had it figured ...
-
Delete all rows that have 0 values in col E [Closed]
Hello, I have invoices that have all employees listed. I am looking for the easiest way to delete the employees that have "0" entered in column E. ...
-
script to send excel sheet at close of excel [Closed]
Hello, Is there a way to write a script to copy a sheet and email it when someone closed excel? I am trying to get a sheet called "Daily Closures...
-
Excel will not do the filter on all rows [Closed]
Hello, I'm trying to sort and filter a file with 167 rows. When I do the filter, it will only go up to row 150. I looks like it will not do anythi...
-
copy row to different sheet based on cell [Solved/Closed]
Hello, I am need to have a script run each time a cell changes to a date in column O, line 12 and after. I have a spreadsheet that has one tab ca...
-
Changing color of a row in Excel [Closed]
Hello, I'm trying to create an Excel spreadsheet that if a cell is greater than 4, the whole row changes color to red automatically (without setting...
-
CONNECTING EXCEL WITH ACCESS DATABASE [Closed]
Hello, is it possible to connect excel with ACCESS database,so that changes made in excel or access should get updated on the other......please help...
-
Calculating exact percentages in excel [Solved/Closed]
Hello, I'm trying to add exact percentages like 99.54%, 84.23% in six cells then calculate the average. I've tried =AVERAGE(A1:B1:C1) but it only ...
-
Excel Nested Formula [Closed]
Hello, I want to use a nested function to locate and flag data in a separate cell. I currently use a complex formula such as in G6 and down (...
-
excel macro to do calculations on csv files [Closed]
Hi, I have multiple comma delimited text files that are generated from an analytical instrument. What I want to do is be: (1) Able to select ...
-
INTERNET BROWSING [Closed]
Hello, Am having a problem when it comes on browsing the internet using my NDKLA n97, am unable to to access hotmail and other useful sites to me,ac...
Subscribe To Our Newsletter!
DON'T MISS
- How to Create a Gmail Account
- How to Recover a Disabled Facebook Account
- How to Get More Followers on Instagram
- How to Fix a Blurry Snapchat Video
- Computer Boots to Black Screen
- How to Upload High Quality Photos to Instagram
- Facebook Code Not Received
- How to Get Free Diamonds in Free Fire
- How to Install a VPN
- How to Recover Your Yahoo Account
- How to Disabled Write Protection on a USB