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. ...
-
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...
-
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...
-
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...
-
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...
-
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. System...
-
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...
-
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...
-
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...
-
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...
-
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",...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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 System...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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 =...
-
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...
-
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....
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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,...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
Muslim Pro
-
Animal Crossing: Pocket Camp
-
Tacticool - 5v5 shooter
-
Resident Evil 3: Raccoon City Demo
-
Minecraft: Education Edition
-
Ukulele Tabs & Chords
-
Amigurumi
-
HEALTHLYNKED COVID-19 Tracker
-
COVID Symptom Tracker
-
Zoom
-
Houseparty