Excel Forum
-
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 ...
-
Copy data from first sheet to other in Excel Closed
I have a workbook for tracking service customers. I would like for some of the data entered in the first sheet (first name, last name, date & email ad...
-
Excel conditional formula Closed
Hello, I need to fixed date (not change by everyday) when A1 CONTAIN certain text like (IR) B1=Fixed date
-
VBA to compare column E from 2 sheets and copy entire row to sheet 3 Solved/Closed
Hello, I have a worksheet where I want to compare values from sheet 1 and sheet 2 and if values in column E (both sheets) are the same to then co...
-
Excel function question Closed
Hello, Which spreadsheet function in Excel will display 6 as the output in the following formula? =(36)
-
Excel formula to track accrued vacation Solved/Closed
Hello, I need help writing a formula in excel to track accrued vacation / personal time. During our employees first year of employment they earn P...
-
If/then formula in Excel Closed
I am trying to write a formula that will add a certain number of days to a date, based upon the written response in another cell ie: if H5="Admit/5 D...
-
Copy rows based on a condition Solved/Closed
Hi How can I have excel copy the entire row of data from worksheet Employee Inventory to another worksheet called EEs if column Q contains TERM. I...
-
EXCEL VBA ET PDF Closed
Bonjour, j'ai un tableau sous excel et je veux le générer en pdf le problème je veux le converti en pdf mais dans un tableau de modèle différent
-
How to merge data from different Excels Solved/Closed
Hello, My name is samar. I have a master sheet which cakculates all oaraneters for my team . To calculate this some raw data is needed . I had...
-
Master sheet and connecting other sheets Closed
I am trying to make a master list of all my donors for charity. The master list will have less information on it then the following sheets. Bellow a...
-
Recalculation of dates Solved/Closed
Hello, Hello, I'm trying to write a formula that will recalculate a date based on a fixed number of days. For example I have 2/1/19 in cell A42...
