Forum
-
copy x rows from a worksheet and paste x rows into another worksheet n times
Hi, I am struggling to create a macro that can copy an excel range of data (A1:B50) from sheet 1 and paste into sheet 2 for 4000 times....
-
False error
Hello, How to remove false error while using this formula *if(c2="A",sumifs(sheet2!AA:AB,sheet2!B:B,sheet1!B:B, sheet2! Sheet1!...
-
Excels with different data
Hi All, sorry if this is already answered. I have two excel sheet having data of customers. the first report is 'old' one and the second is...
-
Finding duplicates between two columns with partial text
Hello, I am trying to compare a list of names in column A to a list of names in column B. I am trying to highlight the names in column A that...
-
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
How to change date with the change in time and how to use if formula for date range
-
excel on Mac
Im trying to setup my friends computer to invoice I have run time 1004 error occurring. Any help please Sub...
-
color cell
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]
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
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
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
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...
-
Excel Macro - Set and autofill a range? [Solved/Closed]
Hello, I am creating an excel macro to reformat a CSV file. In doing this, I need to select a column (F) and replace the values in that column...
-
Help with filtering not working
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
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
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
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]
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]
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]
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...
-
Unable to change date format in Excel [Solved/Closed]
Hello, I have an excel worksheet with a date column, the format is set to dd-mmm-yyyy but the dates in the columns display as mm/dd/yyyy. If I...
-
Montlhy Service
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
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...
-
Copying data from one Excel sheet to another. [Solved/Closed]
Hello, Newbie here. Okay, I have an Excel workbook that houses a form on the first sheet. What I'm trying to do is to automatically copy...
-
IF function?
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
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
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
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.
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
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
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.
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
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
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
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
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
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
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
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
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
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
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...
-
Google Play Store (APK)
-
Minecraft
-
xVideoServiceThief
-
TubeMate YouTube Downloader for Android
-
Instagram for PC
-
Microsoft Office 2010
-
Truecaller: Caller ID & Dialer for Android
-
Adobe Flash Player
-
Facebook Lite for Android
-
YouTube Downloader HD