Excel Forum
-
How to copy a data from one sheet to another, when specific criteria is met [Closed]
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 [Closed]
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 [Closed]
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 [Solved/Closed]
Hello, 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 [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...
-
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...
-
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...
-
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...
Subscribe To Our Newsletter!
