Excel Forum
-
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...
-
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 &...
-
Excel conditional formula [Closed]
Hello, I need to fixed date (not change by everyday) when A1 CONTAIN certain text like (IR) B1=Fixed date System Configuration: Windows /...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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. ...
-
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...
-
Sliding conditional formatting [Closed]
Hi everyone, I am currently stuck in Excel with the conditional formatting. I would like to apply a color to a cell in column A, row 1 based on a...
DON'T MISS
- How to Download Instagram Videos
- GTA Vice City Cheat Codes
- No Sound from Headphone Jack
- Facebook Confirmation Code Text Not Received
- How to Block Private Numbers
- Credit Score
- Get the Transcript of a YouTube Video
- Writing Professional Emails in English
- Reverse Image Search with Google
- Sign Up for a Free Netflix Trial
-
Grammarly Keyboard
-
Amazon Fire TV
-
OnLog
-
Tricount
-
Citymapper
-
YAZIO
-
Candy Crush for PC
-
CallApp
-
Garena Free Fire: Spooky Night
-
30 Day Fitness Challenge-Workout at Home
-
Pokémon Masters