Excel Forum
-
Excel Macro help [Closed]
Hello, I have an excel spreadsheet table (on one worskheet) that has several date rows in one column C, and one cell J12, for a permit number havi...
-
Copy rows of data from one sheet to another [Closed]
Hello, I have used the below code to copy selected rows ("x") of data from one worksheet ("QBank") to another ("TestSheet") within the same workbo...
-
VBA Excel Last Used Cell [Closed]
Hello, I am trying to copy a range of data I have in several columns in a worksheet into one column (all the columns have the same name: OrderID) ...
-
Need Excel Macro [Closed]
Hello, I need a function or macros to compare two cells in two rows and return True if it has partial match. And one more condition to search cell...
-
hiding a different sheet in workbook [Solved/Closed]
Dear sir, I have one worksheet and there are 20 different sheet in that worksheet. I want to show 1 or 2 sheet and want to hide rest sheet. May i...
-
Report from Excel Data Sheet [Solved/Closed]
Dear Sir, I am new in excel. I am trying to use excel for my work easier. I have one excel file where there are different sheet of monthly salary ...
-
I need help with an excel formula [Closed]
Hello, I have a spreadsheet that I am trying to find a average of one column with several rows that if another column with several rows contains a...
-
Excel VB Macro [Solved/Closed]
Hello, I am new to vb and excel. I am trying to create a Macro that will look through all the worksheets in a workbook and find the column named "...
-
Excel issue [Closed]
Hello, There are 3 tables, A, B and c, according to the requirement A = B + C. Need to check the value for B, where B = A - c. Table A contains p...
-
Please resolve my issue ofMS Excel file highl [Closed]
Deat Towa, http://www.speedyshare.com/... Please see the below mention link, What i want is, 1. Those bolt which are consumed completely s...
-
Need Shortcut for full screen in excel [Closed]
Hello, Anyone give me the Keyboard shortcut to change excel sheet into full screen mode.
-
EXCEL MACROS; Clear, Compare and Replace! [Closed]
Hi, I need help creating three Excel macro subroutines.... This is for office 2003! The first one clears cells that do not contain "arg1"...
-
Codes for Reminder creation in Excel VBA [Solved/Closed]
Hello, I want to get Reminder message box automatically, according to the date and time in Excel worksheet. What are the VBA codings & procedures?...
-
Can someone help me write a macro? [Closed]
Hello, I have a large database of information (inventory). The datbase is constantly having rows added and deleted. In column (1), there over 100...
-
delete duplicate items in excel [Closed]
Hello, I need to write a macro where it deletes duplicates but the marcos out there seem to delete all duplicates I just want it to delete a cell i...
-
can not run macro [Solved/Closed]
hello sir, I am trying to put macro in any excel sheet then "can not run the macro" the macro may not be available or all macros may be disabled. ...
-
how to create shortcut keys to xl 2007macros [Solved/Closed]
Hi, I created few Macros in excel 2007,these working fine but how to assign short cut keys to these macros.In macros window in options property is ...
-
Ignoring rows with zero value [Solved/Closed]
Hello, A couple weeks ago ya'll helped me with some code to compare two sheets and create a new worksheet with all of the values that were identic...
-
excel delete blanks help [Closed]
Hello, I have a macro to delete rows where if the cell in column c is blank as follows: Columns("C:C").Select Selection.SpecialCells(xlC...
-
Highlighting the values entered in an excel [Solved/Closed]
Hello, Dear All, I have a question to ask, Actually i am working with an Excel File which has so many sheets under one file, and this file ...
-
Copying Data To Another Worksheet [Solved/Closed]
Hello, I have the following data in worksheet named "Auto Entry" Cell A1= X Cell A2 =Y Cell A3 =Z Cell A4=Input Value(1,2,or 3) In Cell A4 is...
-
Excel: matching and sorting [Solved/Closed]
Hello, Ok, how sould a computer dummy to this (the dummy is me): I have a list of 300 bike racers. In the columns next to the racer is items such a...
-
Inputing selling price into excel [Closed]
Hello, I have a list of table in my excel as below: Stock Code Supplier Description Selling Price 3MAY018 NIEHA DRESS 3MAY01...
-
Sum data value of different sheet of excel [Closed]
Hello, I want to found some formula for summing different sheet. My problem is like this. I am one excel worksheet, there are different 12 sheet...
-
can someone please write me a macro for excel [Solved/Closed]
I want to be able to input a number into a cell and have that number recorded in a list elsewhere within the same sheet. Then be able to replace tha...
-
how to find a cell in a macro.. [Closed]
Hello, I am creating a macro and what i want to to do is to find the word "Tylenol" and then go to the cell beside it and i want to put a formul...
-
Excel [Closed]
Hello, I have created a calendar in excel, it can update automatically once the year is entered. I have another sheet "Customers" with "customers li...
-
EXCEL Help Required [Closed]
Hi, Basically I have a document that is 30,000 lines long showing data in 1 second intervals. I would like to delete all the data so that I have in...
-
excel tips needed [Closed]
Hello, I have salary sheet for different months for different workers. Some of them are not in one month and another new worker are add in new mon...
-
To set 4 PageBreaks by VBA in Worksheet [Closed]
Dears, I would be very grateful If someone can help me. I have several sheets in one excel file. I need one command button when pressed to set 4...
-
copy selected cells to new sheet in a row [Solved/Closed]
Hello, dear all, I have an invoice template in the range b6:f57 in one sheet.. I want to select only some cell contents like c17, f17, f 19 , f 32, ...
-
Formatting date in Excel Sheet [Closed]
Hello, I am working in SAP wher i generate a report which download in excel sheet in dd.mm.yyyy format but i need convert it to mm/dd/yyyy format ...
-
VBA-conditionally selecting and copying data [Closed]
Hello, I have a file with 5 columns. one with date, time, latitude, longitude and amplitude. I need to conditionally select data from the latitud...
-
how to copy data from one sheet to another [Closed]
Hello, I am having a workbook. In sheet 1,m having store name in column A(A2:A9),in column B inventory for soap ranging B2:B9,in column C inventory...
-
Internet connected but can't browse [Closed]
Hello, today I saw the 3g modem HUAWEI is connected, antivirus can update database but I can't browse the internet. I trid to delete Uniblue PowerSu...
-
conditional copy and paste using macro [Closed]
Hello, Just want to seek help to anyone about my problem about copying and paste multiple cells from sheet 1 to new sheet hru new sheet also with ...
-
Match up Names in Excel or Access [Closed]
Hello, I have a list in excel of of car types in column A and the owners in column B. A lot of owners have multiple cars of the same type making a...
-
generating reports using macro in excel2003 [Closed]
Hello, Hello I have a task to be done once on every month-end. I am working in a private bank. I have a file called BaseFile. I need to generate re...
-
Is there a way to delete all dates in excel [Closed]
Hello, Is there a way to delete all dates in an excel workbook without deleting the actual cell they are in? For example, I have some cells that s...
-
Reading an excel and filter data and add. [Closed]
Hello, I have an excel say Book1.xls. I will have data with 10 columns and 10 rows in it. I will have another sheet in the same excel. I will ha...
-
macros help [Solved/Closed]
Dear Friend i want to convert number to text in excel programme Example : ( 055555 : Zero five Five Five Five Five ) As This Format ...
-
Transfering data to a new sheet [Solved/Closed]
I'm running excel 2007 on windows 7, if that's important. I'm trying to find a way to transfer data from a master sheet (or basically sheet 1) to...
-
Format data in excel for Db transaction [Solved/Closed]
Hello, I have a simple question, I have a range of cells with numbers in each cell. I want to add a single quote or apostrophe in the start and end...
-
Create Macro replace blank cells with COUNTA [Closed]
Hello, I want to create a macro that will find a blank cell with Counta value of > 0 and delete that entire rows. Configuration: Windows XP / I...
-
Excel Macro to copy text and append [Solved/Closed]
Hello, I recorded a macro in Excel where I copied the text from one cell and appended that text to the values in several other cells. The problem...
-
Using conditional formatting in excel to high [Closed]
Hello, I want to highlight the row based on cell value. For example. If I put 10 in one cell, it should highlight 10 rows like that. please advise...
-
cell reference to locate /store data in excel [Solved/Closed]
Hello, Hello , I am working for a newly started airline agency. I am enclosing my working file (for privacy sake , I have changed names and oth...
-
Copy Row in Excel to Specific Tabs [Closed]
Hello, I'm not very smart once I get outside of if-then formatting. I have an excel worksheet. It is used to track purchases for different divi...
-
Excel equation [Closed]
Dear sir, I shall be much obliged if u solve this equation using excel formula is E = P×r×(1 + r)n/((1 + r)n - 1) (here n is power plz dont read i...
-
Average above "n" rows in blank row [Closed]
Hello, I'm working on a dataset of historical price data. The set has dates in column A, and prices in column B. Through a macro I have inserted a...
Subscribe To Our Newsletter!
DON'T MISS
- How to Get Free Diamonds in Free Fire
- How to Create a Gmail Account
- Computer Boots to Black Screen
- How to Recover a Disabled Facebook Account
- How to Disabled Write Protection on a USB
- How to Install a VPN
- How to Recover Your Yahoo Account
- How to Get More Followers on Instagram
- How to Fix a Blurry Snapchat Video
- Facebook Code Not Received
- How to Upload High Quality Photos to Instagram