The discussions
Can someone please write me a macro for excel
SolvedI 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..
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
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
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
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
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
SolvedHello, 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
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
ClosedHello, 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
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
ClosedHello, 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
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
ClosedHello, 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
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
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.
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
SolvedDear 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
SolvedI'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
SolvedHello, 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
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
SolvedHello, 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
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
SolvedHello, 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
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
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
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
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
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
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
SolvedHi 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
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)
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
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
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
SolvedDear 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
SolvedDear 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
SolvedHello, 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
SolvedHello, 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
SolvedHello, 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
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
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
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
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
SolvedHello, 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
SolvedHello, 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
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
SolvedI 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
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
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
SolvedHello, 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...