Excel Forum
-
Formula/Solution Closed
Hi, Is there a way for me to link in one spread sheet the Leave Dates that will automatically apply to the specific date in a second/third/forth sp...
-
VBA Regex Closed
i need a help to create regex to use in Excel vba. Actuality 3 regex 1. Only Numerics Valid: 12,12.000, 2343342.123221321398783, 0.9874, -12, -2...
-
Compare two excel file and provide unmatched excel data in separate file Closed
Hello, I have two excel files with common identification column A in both files. I need macro which will provide unmatched data in separate file. ...
-
use RegEx in vba sub in general sheet Closed
How to use regex in general vba sheet. i am getting lot of red lines and not able to find the reason for that. I have enabled the Regularexpression...
-
Listboxes with Checkboxes to filter data Closed
Hello, Greetings! I have a query regarding making dashboard. I have a data sheet where all data is managed. I want slicer with listbox having ...
-
read special character value Closed
how to read the cell value in vba if A1 has special character like -------- I used Range("A1").Value , Its throwing an error plz help me
-
VBA code to count invalid Values Closed
Hi, I have created a vba code to circle the invalid data based on the custom data validation rule being written. I want to count the all those i...
-
Automatically update a cell with last modified date and time Solved/Closed
I am maintaining a Test Environment Catalogue, with various users editing it. It is change controlled in SharePoint, however, I'd like to insert a cel...
-
Repeated copy/paste Macro Closed
I have basic knowledge of Macros. I need to copy 1Lakh data in such a way that it takes 10k rows and paste in new sheet1 and again it takes next 1...
-
Keeping track of ages Closed
Hello, I operate a small daycare and need help figuring out a system to help keep track of my group ratios. I haven't been able to find a software...
-
Please help me connect my workbooks to a master excel worksheet. Closed
Hello, I have been through every excel video and forum trying to figure out how to connect my Excel workbooks for a tracker I have been working on. I...
-
VBA find column by name and sort Solved/Closed
Hello, I am trying to make a code that should: - Go to the first worksheet - Find the first column with header "sku" - Sort this column ascen...
-
copy x rows from a worksheet and paste x rows into another worksheet n times Solved/Closed
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. Currently, sh...
-
Create new sheets based on Column A data. Solved/Closed
Hi, Is there a way to create a new tab based on column A? For example: I want to create a new tab for each vehicle, copy and paste all of vehicle ...
-
False error Closed
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! A:A))*
-
Excels with different data Closed
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 the '...
-
Finding duplicates between two columns with partial text Closed
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 matc...
-
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...
