Excel Forum
-
Replace 'sheet' reference in a formula (not copy data, but get averages) [Solved/Closed]
Hello, I'm working with a precipitation data base of multiple sheets. Each sheet is a year of measurements. The thing is that I'm trying to ge...
-
Copying Excel data from one sheet to another based upon contents of a cell [Closed]
Hi, I have a spreadsheet containing two sheets. Sheet 1 contains the following: Col A - username Col B - Full Name Col C - Email address Col ...
-
Am not too good on percentage calculation [Solved/Closed]
Hello please what is the 10 percent of,7200000000
-
How to duplicate rows x number of times [Closed]
Does anybody know how I can repeat rows in a spreadsheet by n number of times specified in cell B in that row ie from this table: Column A, Col...
-
Follow up Q to how to add a certain number of days to a date in excel [Closed]
Hello, Thank you for your article with the handy tip. What way would one make use of to fill the contents of a single row (or column, depending ...
-
Macro to copy/paste down X times (where X is the number of rows) [Solved/Closed]
Hello, I could sure use some help on a Macro. I need to copy the value in E1 and paste down to all cells in column E (E2 to E??) The issue ...
-
Compare sheets macro [Closed]
Can you please help me with the code for comparing two spreadsheets and giving the result in a separate sheet. The range may be different for the two ...
-
Which macro (of many) changes the data in my workbook [Closed]
I am working with an old macro enabled spreadsheet that has many tabs and many macros. On one tab I have a column that reports "yes" or "no" when the...
-
Formula to subtract one cell value from another. [Closed]
Hello, I am trying to do a formula that would subtract cell a2 from a1 if cell a3 has "Closed" in it. Is this possible?
-
Auto Transfer questioner with right answer to another sheet [Closed]
Hello, I have questioner list (yes or no) about 60question. I want to make it automatically transfer (all the row) to another sheet if answer is ‘N...
-
Insert Picture in Ms Excell [Closed]
Hello Friends, Please help me out, how I can insert the picture in front of the name automatically. Means I just select the images these pictures auto...
-
partial matches in lists of 6-digit numbers [Closed]
Hello! I have a list of ~500 6-digit numbers. They were all hand entered, and we want to proof the list and see if any of them were duplicated by typi...
-
Formula to create generations based on birthday [Closed]
I need a formula in excel that will indicate generations based off of a birthdate. Generations: Traditionalists (Prior to 1943) Baby Boomers (194...
-
Copy and paste selected cells a given number of times [Closed]
Hello, I had a quick course on macro and I would like to write my first one, but I would need some help with it. Id like a macro which copies t...
-
Send mail if today is the birthday. [Solved/Closed]
Hello, I have a Excel sheet containg profile of some employee like this: Name ID Date of Birth Rahul 335221 15...
-
Comparing Two Excel Sheets and copying like data to third sheet [Solved/Closed]
Hi, I'm trying to compare two sheets in excel and have matching column data copy the entire row into a new third sheet. Ex: Compare Sheet 1 column...
-
Getting multiple largest values with specified limits [Closed]
Hello, a1 is 110,a2 is 236,a3 is 175,a4 is 352,a5 is 257,a6 is 175.In b1 find value is greater than or equal to 400.i need all answers numbers not re...
-
Extract data from few XML file into Excel. [Closed]
Hello, i hope someone will be able to assist me, and i hope it is possible to do what i need. I need to extract specific data from a few XML files...
-
COMPARING 7 COLUMN [Closed]
HI I WOULD LIKE TO KNOW HOW TO COMPARE 7 DIFFERENT COLUMNS AND FIND COMMON VALUE IN NEW COLUMN I'M ATTACHING ONE SAMPLE HERE PLEASE CHECK AND...
-
Trying to insert multiple rows between rows in excel with copied data. [Closed]
Hello, I have used the two listed vba macros but i am having no luck combining the two. First one to add 13 rows between current data: data is on ...
-
Using a Named Field for Autofill [Solved/Closed]
I am performing an Autofill using a macro. Is there a way to enter the ranges using a "Named Field" in the macro without having to hardcode them in t...
-
Find and Replace using VB; from a txt file, find all commas "," [Closed]
I need to find all occurances of a comma "," in a txt file and replace it with a blank space and output a csv file. Is there an easy way to do this in...
-
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 with a...
-
Excel autofilter stops filtering [Solved/Closed]
Hello, 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 [Closed]
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 [Closed]
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 [Solved/Closed]
I 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 [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
Subscribe To Our Newsletter!
DON'T MISS
- How to Upload High Quality Photos to Instagram
- How to Get More Followers on Instagram
- How to Create a Gmail Account
- How to Install a VPN
- How to Recover a Disabled Facebook Account
- How to Recover Your Yahoo Account
- How to Fix a Blurry Snapchat Video
- Facebook Code Not Received
- Computer Boots to Black Screen
- How to Disabled Write Protection on a USB