Excel Forum
-
Arrow keys not working in Excel Solved/Closed
Hello, I am using Excel 2000. I am tring to move from one cell to another in Excel by using the arrow keys on my keyboard but nothing happens. I wa...
-
How to change date with the change in time Closed
How to change date with the change in time and how to use if formula for date range
-
excel on Mac Closed
Im trying to setup my friends computer to invoice I have run time 1004 error occurring. Any help please Sub NextInvoice() Range("I13").V...
-
color cell Closed
Hello, I have this formula to place a date in cell when negative number. =IF(D14
-
I want to change date format in Excel Solved/Closed
Hello, I want to change date format from SAP system i.e. 20.05.2010. When I apply thru format cell it doesn't work.
-
Need to extract specific XML data from a cell in excel Closed
Hi, I have the following data in cell A1 of an excel sheet: 39211000011200100100019 i would like to extract the value from this and print it o...
-
Automatically data to another sheet by adding new rows Solved/Closed
Hello, I have created a "request form" - the form is not designed in VBA - it is simply a spreadsheet using Column B, only, and each row has either ...
-
Creating search and update command buttons in a userform Solved/Closed
I have created a userform for inputing new records in an Excel spreadsheet. I have written the code for the Save Record and Close Form command button...
-
Update of Copied Excel sheet Closed
Hello, I want to make copies of excel sheet such that if I delete rows/columns in main sheet they should be deleted in copy too.
-
Serial Numbers Based Upon Another Cell Closed
I have a spreadsheet with owner and tenant information, along with their vehicle information. In the column that indicates if they are an owner, I hav...
-
Compare strings Closed
Hello there, Case: I have lists of customers from 2 different sources, however example. List1 says ABC private limited on row A1, the other list2 say...
-
Help with filtering not working Closed
Hello, I am having issues with my excel at work we have about 8 columns an they have filters an when I type in data an click the filter to go to tha...
-
Copy a range of Data in Column with a loop Closed
Dear all, May I ask your help for a macro which allowed me to copy a range (column) 16350 times :-) On D5 to D369 I have a formula which do a rando...
-
Shows a #value! When using calculated fields on a pivot table Closed
Hello everyone I would like to input a calculated field in the excel pivot table. I have input an formula as if(ERP (Variable)>0, "Yes", "No"). It...
-
User form to search all result and edit selected Closed
I'm newbie in VBA excel. I want to create usesform to add, search all result and edit selected. Any one have code like this? Thanks
-
compare 2 sheets with particular columns Solved/Closed
Hello, hear is the situation, sheet1 is having "item code (ex. 150007) in column A", and "Rack ID in column B (ex. AA001)" & other side in she...
-
Add data to row that already contains data Solved/Closed
I want to enter data for the same product but it needs to be done on different days, with two different entry forms, so the row will already contain d...
-
Automatically copy data from main sheet to child sheets. Solved/Closed
Hello, I know this question was asked in another thread (https://ccm.net/forum/affich-800808-need-to-automatically-copy-data-from-one-sheet-to-ano...
-
Montlhy Service Closed
I have an increasing excel sheet where i keep the service records for customers per customer, per branch and per date (per year, month and exact servi...
-
Need VBA Code or function Closed
Hello, kindly need assistance in getting VBA code to copy rows to a new sheet based on the cell value with same name sheet. and auto save the...
-
IF function? Closed
I am trying to figure out a function, that will give me a result of Yes or No, if the dates are matching or not. This is the function I am using, ...
-
Inserting pictures Closed
Hello, Please I need help, I want to insert pictures into a particular sheet remotely without opening the sheet. And the picture will be base in ...
-
i want to convert figure or digit to word but without rupees or dollar Closed
Hello, i want to convert figure or digit to word but without rupees or dollar, i just need only at the end of words, please help
-
Populating multiple cells with information pasted on a main sheet Closed
I am trying to paste data every week in the same cells (B2-B12) on my main page and have that data populate cells on 12 separate pages. All 12 pages w...
-
Help getting data from one worksheet to the next. Closed
Hello, I am trying to set up a master job sheet for all of our field employees to have the information in the field. The links to the 2 sheets are...
-
Adding date depending on the day of the week Closed
Hello, I want to automatically calculate a date when an invoice is due depending on the day of the week. For example: the service is provided o...
-
Transpose VBA Excel Closed
Hi, I require a macro that performs a specific transpose action. Please see pre table example and desired post data set. I have searched for t...
-
Updating other Excel sheets automatically from Master sheet. Closed
Hi, I have been trying to sort this for a while. I have entered data in my master sheet and I have 4 other sheets. When I put new data into the mas...
-
Copying formulas to multiple worksheets Solved/Closed
Hi, I have a workbook that contains 32 worksheets. 31 identical sheets that are basically days of the month. Last one is a summary sheet. I have t...
-
Give a cell zero value depending on another cell's value Closed
I have an interesting challenge I am a altra marathon runner busy creating a "log program" for my running Cell A1 = Distance Ran Cell B1 = Hours C...
-
Copy data and pasting multiple times using macro Closed
Hello, So I am having trouble determining what code to use to past value. The situations is as follows: On Sheet1 I have a list of names in co...
-
Auto Xfer Specific Data to a New Wkst Closed
Hello, I have a raw data file of sales opportunities and would like to automatically identify and copy the TOP 10 Optys onto a new Wkst. Further, ...
-
Excel VBA- Copying data from newest worksheet to a new workbook Closed
Hi all, Newbie here. I've been fumbling around with VBA and managed to get some parts working, but now I'm stumped. I have an Excel workbook tha...
-
Copy data onto sheet only if cell has text Solved/Closed
Hello, I need to copy formulas and data from a selection of cells in a worksheet (Figures) onto a seperate sheet (summary). I would like the inf...
-
Repeat a set of rows in Excel Closed
Hello, I have some set of unique row in a1 to a10, and I want to repeat the whole set of row in same column eg."A" by some given no. Of time by a p...
-
Formatting a cell for multiple functions in Excel Closed
Hello, I would like to have my dates be highlighted red when expired and yellow highlighting the dates when 30 days prior to being expired. I alrea...
-
Split data into several rows of same data Closed
Hello, I would like to split a row of data into several rows of same data in MS Excel. I will try to explain the situation. I need a macro that...
-
Send Automatic emails using Macros Closed
If column F in any worksheet in entire workbook is changed to "Pending" send an email. Below is my macro so far. Sub Request() Dim OutApp As Ob...
-
Copy more than one cell in Excel if a condition is met Closed
Hi, I need to copy more than one cell if a condition is met. It’s about student degree. If the degree between specific range, then I need to copy m...
-
Pulling data from multiple sheets to master sheet Closed
Hello, I am working on a project and I could definitely use some help. I have an excel file with four sheets: Master Sheet, Project A, Project...
-
VBA code to open non excel programs Solved/Closed
Hello, I need vba code to open other documents besides excel doc's e.g open a word file, access file etc.. Can anyone help?? thanks PM
-
Excel 2007 file Excel found unreadable content in <filename.xslx Closed
Good day, I have a computer set of Excel files, all in working order, but today one of the files when opening gave an error: "Excel found unreadable ...
-
Problem with copy in one sheet Solved/Closed
Hello, There is a table on sheet1 for example. A B C D E 1 2 3 4 5 In cell A1 I drag the data from sheet2 cell A10 In cell A2 I drag t...
-
I have a problem regarding how to automatically update data in other Sheets. Closed
Hello, I m looking to have few different sheets that automatically updated based on information that is added or changed in master sheet. One shee...
-
Automatically move an entire row of expired item from one sheet to another sheet Closed
Hi, I have a problem with the code below. I am a store officer in the firm I am currently with, and monitory of expiring date of a product is par...
-
Copy worksheet from one workbook to another workbook in MS Office Excel Closed
Hello, In the Move/ Copy dialogue box, the destination workbook is not visible to copy the worksheet from the source file.
-
I need VBA that creates a new sheet for every data entered in column D Solved/Closed
Hi, I need a formula that create a new sheet for every data in "D" column cells and sheet name is like the cell ,also add that cell whole row data ...
-
Budgeting forumla in Excel Solved/Closed
Hi! So I'm trying to write a budget for my household. Payments are made from different accounts. I've included an example. If anything in Colu...
-
Macro in Excel Closed
bonjour je bloque sur ma macro depuis plusieurs jours et j'aurais besoins d'aide j'ai un listing de 13 colonnes qui peut aller jusqu’à 50 lignes m...
-
Copy rows n times in Excel Solved/Closed
Hello, I Need to copy from rows from A1:AY39 and need to insert in A41 and the same as be pasted on next 38 Row from A41 and it as to be done for ...
