Excel Forum
-
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...
-
Copying data from one sheet to another [Closed]
Hello, Macro newbie here. I'm trying to copy 351 rows of data from one sheet and paste the data to every 14th line on another sheet. Help! DR ...
-
IF statements in Excel [Closed]
Hello, I'm looking for some help with conditional coding in excel. If text is entered in one of eight specified cells, then I would like 1 added t...
-
If statement in Excel looking for text [Closed]
I have a column with 3 text labels (book, pencil, eraser). I want to create a new column where I can find cells in the original column that have eith...
-
Excel macro help [Solved/Closed]
Hi there, I am getting an error when I try and run the following macro. I am trying to find the value in one worksheet (final) in another worksheet ...
-
2 sheets compare for differences [Closed]
Hello, I have excel workbook with sheet1, sheet2 that have same data in column A. I need to find the difference in the 2 sheets. The records tha...
-
Roman number series (macro) [Closed]
Hey guys. I need to make macro witch makes series of Roman numbers (Similar to built in excel series- http://i63.photobucket.com/albums/h129/Edds87/...
-
Macro for Printing in MS Excel 2007 [Closed]
Hello, I have standardized reports that I create in MS Excel 2007 on a daily basis which must be printed under certain parameters. How do I creat...
-
Excel Date Format [Closed]
Hello, In the Excel sheet I have dates are in the format dd/mm/yyyy. How do I format it to be yyyymmdd ? . Your quick responce will be much ...
-
Delete AllowEditeRanges by VBA [Solved/Closed]
Dear All, Can some-body help me to correct the following code: Private Sub CommandButton1_Click() Dim WS As Worksheet Dim aer As AllowEditRang...
-
Delete AllowEditeRange by VBA command [Solved/Closed]
Dear All, Can anyone help me to correct the following code: Private Sub CommandButton1_Click() Dim WS As Worksheet Dim aer As AllowEditRange...
-
Excel Conditional Formatting Rows to Columns [Solved/Closed]
Hello, I have a data set that looks like: A B 1 20 2 21 3 21 4 03 1 19 2 34 3 23 4 25 1 23 2...
-
HELP about macro copy and paste [Solved/Closed]
Hello, Just want to seek help to anyone about my problem about copying and paste multple raw and column thru new sheet also with designated raw an...
-
Copy to first open cell in rowB/sheet 2 [Solved/Closed]
Hello, Thanks for trying to help! I have a sheet as shown below. We do sales every day and would like the values/ estimates and sales that have...
-
Excel Time Clock Spreadsheet [Closed]
Hello, Can somone please try to help me? I have a Finger Print Time Clock. I am exporting the data into Excel, that looks like the first to rows, i am...
-
how to print excel data in form in excel 2003 [Closed]
Hello, I have lots of data in a excel sheet I want to print it in a particular form . pls some one help me how to print excel data in ...
-
Office for mac excel problem [Closed]
Excel (Office For Mac) When trying to enter a date the letter "y" inserts itself into the date, no matter what format I use. I wish to enter the da...
-
highlight all the rows containing same name [Closed]
Hello, I have an excel in which one of the column(D) has duplicate entries for name.If clicked on a particular name, I want to highlight all t...
-
VBA - how to replicate the value n times [Solved/Closed]
Hello, I have to write in VBA a macro that allows to replicate value n times (input). Let's say, I have a list one two three and I have to re...
-
Help required in MS Excel [Solved/Closed]
Hello, I have a list of text strings in rows separated by blank rows. For example: Row 1: Name of the publication Row 2: Authors Row 3: Organiz...
-
Stop duplication in excel worksheets [Closed]
Hello, I have set up a workbook with multifple worksheets. Each worksheet will have different data. I created each worksheet from a copy of the ...
-
how to compare columns of 2 different Excel [Solved/Closed]
I want to compare column named employeeid in two different EXcel sheets and have to retrive the rows with same employeeid ex: sheet1 emp name ...
-
VBA Module with checkboxes to use in excel [Closed]
Dears, I will be very grateful if some one can help me in the following. I have excel file include 50 sheets for customers, in each sheet I have 2...
-
Delete data in excel with macro [Closed]
Hello, plz can u sent coding for following matter: i want to use macro in exl which is find the total word & del all data from right side plz pl...
-
Excel If Then, create a new column [Solved/Closed]
Hello, I'm trying to write a VBA code, because I have too many factors to create a nested function. I can do it fine if there were less than 7 variab...
-
conditionnal formatting using macro [Closed]
Hello, I am trying to create a calendar in excel in which certain days shoulded be marked with a colour. In my excel file, one day is one column ...
Subscribe To Our Newsletter!
DON'T MISS
- How to Fix a Blurry Snapchat Video
- How to Upload High Quality Photos to Instagram
- Computer Boots to Black Screen
- How to Get More Followers on Instagram
- How to Recover a Disabled Facebook Account
- How to Recover Your Yahoo Account
- Facebook Code Not Received
- How to Install a VPN
- How to Disabled Write Protection on a USB
- How to Create a Gmail Account
- How to Get Free Diamonds in Free Fire