The discussions
Excel macro - set and autofill a range?
Solved/ClosedHello, 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 with a...
Excel autofilter stops filtering
Solved/ClosedHello, I am working with Excel 2003 professional and just yesterday after entering a bunch of records to my file, which has about 19,000 rows, I di...
Formula for conditional format to color cells
hi, need a formula or conditional format: if cell a1 has text, then apply the color RED to cells underneath say a2-a15. then, once numbers are i...
Save excel file as specified titles in different workbook
Hello Trowa and team, I just saw you solved a task for another user, who wanted to recreate a file with specified names in the list. I have a s...
If a cell contains any text then add a value
SolvedI hope someone can help me with this...I've done this before but can't remember how. I have a list of names (for an attendees list) and I need to s...
How to copy a data from one sheet to another, when specific criteria is met
Hello, If, for instance, the criteria changes in column "C" - it gets higher number, how to transfer the row data to other sheet2, copying the row d...
Need to delete rows in multiple sheets simultaneously
Hi I have a worksheet that has 3 sheets. Sheet 2 and 3 have data linked from sheet 1. If I delete a row in sheet 1, I want to have the correspondi...
Vba code to apply in each monthly worksheet
Hi, I have a monthly creditor file (create new tab for each month when required) and want to calculate the amount outstanding each month, which is ...
Formula in excel to turn numbers into text
SolvedHello, I found formula but sir I want at last as per below. As per formula =words(1234) = one thousand two hundred thirty four But sir I wan...
Formula/solution
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...
Use regex in vba sub in general sheet
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
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
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
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
SolvedI 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
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
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.
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
SolvedHello, 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
SolvedHi, 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.
SolvedHi, 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
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))*
Arrow keys not working in excel
Solved/ClosedHello, 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
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 NextInvoice() Range("I13").V...
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/ClosedHello, 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
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
SolvedHello, 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/ClosedI 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
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
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...
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 tha...
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 rando...
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
SolvedHello, 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
SolvedI 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.
SolvedHello, 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
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...
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 using, ...
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 in ...
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
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 pages w...
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 are...
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 provided o...
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 for t...
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 mas...
Copying formulas to multiple worksheets
SolvedHi, 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
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
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...
