The discussions
Generate excel workbooks based on excel list
SolvedHello, I need to generate several hundred identical excel workbooks using a macro. I'd like to standardise the file names based on a list in Excel...
If then
SolvedIm trying to write a formula that returns a yes or no. I have to check if product is or isnt in warranty and need to know if a date is greater than o...
Email with multiple attachments through vba
SolvedDear All, I need to send the multiple emails via Outlook through VBA. Column A Row 2 = Name of Person, Which must be Displayed on .Body Column B Ro...
If and is text or is not blank
SolvedHello, Can somebody help me with this formula...I want the excel to display a computation, if A2 is a Seller, and A2 has a value, then compute Price...
Conditional formatting range of date cells based on another cell
SolvedHi There, There is lots of stuff to do with CF when using today's date but not a for specific date entered in a cell so I was hoping someone might be...
Search for a keyword. add value from another cell.
SolvedI'm looking for something that's very difficult to search for. I balance my checkbook in excel. Each row has a spot for Date/Comments/Withdrawl/Depos...
A if(istext) formula that needs a trimming, please help?
SolvedHello, Am really struggling with a IF(is text) formula, it works its just really large and I need to be able to trim it a bit as I need to replicate...
Worksheets into workbook
SolvedDear All, I need to copy each worksheet into workbooks and saved in the specific path except 04 worksheets named NMS, MS, Master and Missing. Further...
Text from two different cells to give value shown in certain cel
SolvedHello,, I'm trying to solve a problem I have with a list of values and text. I have a schedule of with names I will get two values in different cel...
Conditional formatting for word and date
SolvedHello, I am trying to make a cell turn a different color depending on if another cell has a word in it and if the date of a third cell is between tw...
Auto copy and paste cell range to a separate sheet
SolvedHello, I am new to VBA/Macro with excel, but I want my code to automatically copy a range of cells in the same row that a change is made in a particu...
Need to create multiple tabs based on data in table
SolvedGood Afternoon, I'm trying to find a way to automate a few things to save some time: -Use the data in an input tab to create multiple tabs/documents...
Function in excel 2013
SolvedHello Dear All. who I can do this function in excel 2013 If A2=AB return value from A1 cell , if A2 = CD return from A3 cell value Configuration: W...
Cell format - countif then subtract from another cell
SolvedHi, I have a spreadsheet with holidays on. I'm using =COUNTIF(D16:D380,"H") I want to then subtract this number from another cell - What do I need ...
If/then formula help
SolvedHello, I could use some help on the formula below. I need cells in one column (Y) to show specific text ("SEND") if cells in another column (G) has ...
Date format
SolvedHello, i am trying to create a report which will show me the first date and last date of the previous month. I need first date in one field and seco...
Building a new spreadsheet using information from another
SolvedHello everyone, I'm new to the forum and VBA and would like to thank you in advance for your assistance. I have received a spreadsheet that contains...
Run macro automatically
SolvedHello, I wrote a macro and I want to run it automatically if one special cell change but have problem, because contents cell change by formula in oth...
Macro copy and paste in next blank cell
SolvedHi guys, I need some helping in excel macro. I have two sheets in a workbook. Sheet1 is for summary and Sheet2 is for the raw data. I need to update/...
Automatically copy the values from the active row from sheet
SolvedHello, Struggling already for a couple of days.... so a help would be more than welcomed Need to write a macro in Excel which would: automaticall...
Macro to copy entire row to next workbook
SolvedHello, Configuration: Windows 7 / Firefox 50.0 I have the following macro to copy entire row when the column has a capital X. I would like...
A and b column query to provide sum of column c
SolvedHello and thank you for your help. Please use this scenario for reference: - A B C 1 abc x 1 2 abc y 2...
Search, find & display
SolvedHello, I have been manually filling out the week no's, in a budget sheet, but want to try and auto populate. I have a table with dates and Week No...
Change cell color based on another column
SolvedHi All, I am not very good at excel, however I am looking for a solution for the following problem. There are two columns (Column A and Column B...
How to make an excel sheet equal to another
SolvedHi, I'm new in Excel, and what I'm trying to do is this: I want to make an entire sheet equal to another, except for one cell, so if I change somethi...
Copy paste rename based on cell value
SolvedHello I have a worksheet named template. I need a VBA code which would copy "template" automatically into a new worksheet and rename the new wor...
Searching for values and creating a list
SolvedHi there, I hope you can help me, so far I have managed to create a formula which searches a range of data (SKU’s) and returns a count of the occurr...
How to find value from a column with unique random values
SolvedHello, I need a formula that can get me a value from a column that has unique values and return another cell from that row, can someone help me? e...
Auto generate workwheet from a list and from a template workshee
SolvedHello All, At the moment, I found out how to auto generate worksheet from a list. However, the generated ones are blank worksheets. May I ask ho...
Excel - a macro to rename existing worksheets based on a list
SolvedI have a P.O. spreadsheet with a summary page. Every year we need to create a new file but I would like to create a template that would just renumber ...
Inserting image in a particular cell in vba
SolvedHello All, I wanna insert an image into the Activecell but the image is getting inserted into the same default area. Kindly help me regarding this...
If statements with dates and criteria
SolvedHello, I needs assistance with "If "statements and criteria within the statement . Column A has a set of start dates Column B has a set of En...
Duplicate values in multiple columns
SolvedHello, I'm looking for a formula for a case mentioned below: Consider we have values in three columns I need to find a formula which compar...
Copy data of one sheet to other sheets
SolvedHello, I want a VBA code or excel formula that automatic copy of data from one sheet to another sheets(either sheet 2 or sheet 3...etc)..suppose In ...
Copying & pasting data in next available row in same worksheet.
SolvedHello, I would really like assistance to write a vba code for a macro (using a drop down list) that copies data from A4:E4 and pastes it down in t...
Value from matrix table
SolvedTrying to get rate in G14 that comes from the matrix E14 is a list of A3:A10 F14 is a list of B2:J2
Two tables values with diffrent order and number of values
SolvedHello, I have 2 tables of products (diffrent number of products). 1st table contains: all products (name, SKU): NAME | SKU asd.........21398763 ...
Calculate my service expense as %
Solved/ClosedHello, I would appreciate if someone can help me with this problem solving question. I would like to know how to calculate my Service Expense as % ...
Error "range of object global failed"
SolvedHello Everyone, Kindly check my code for mistakes. I am getting an error in this part of my code as "range of Object _Global failed". Dim feat...
Excel- if this, than return that?
SolvedBackground: I work for a Recruiting Group & we have a list of candidates in Excel with all mailing info, including the County they live in. I need to...
Trying to concatenate a letter with a date
SolvedHello, I'm trying to keep a date in a recognisable format and precede it with a character. e.g. I want "D" and 27 July 2015 to appear as D 27 J...
Insert picture in excel macro, after crop it, save it to a file
SolvedHello friends, I need to open a macro, after place the name in A1 cell, push a button to insert a picture, base on A1 name, then, after crop it and re...
Find words within cell & put text and color in adjacent cell
SolvedHi there, i'm trying to search for certain word(s) (i.e. "reply??" or "remind") in a cell with a sentence in it, and place a specific text on a diffe...
Macros: copy invoice details from one sheet to another
SolvedWould be very grateful for help with this one I have set up a macro that will print and generate the next reference for my invoices raised in excel, ...
Calculation of positions in excel
SolvedHello Hello, sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...
Excel macro's copy data from one sheet to another
SolvedHey Everyone ok, so, I have a document with multiple sheets one of the sheets is a reporting sheet what i am trying to accomplish with not much l...
Get a value from col a based on the max value found in col b
SolvedHello, Get a value from Column A based on the max value found in Column B display in Column C. I need to get value Jill in Column C. Name A...
Comparing dates in multiple columns and using one that matches
SolvedHello, I have a table with multiple columns of date values and need to check whether a date in a certain column is less than that date and depende...
Create & name worksheets from a list and copy data
SolvedHi Guys Really new to this and thanks to previous posts on here I have managed to create code to complete the first part of my jigsaw, just struggl...
Formula question: "if" function with date
SolvedI am attempting to create a formula that will enter "Yes" into cell P1 if: the date in Cell E1 is before 07/31/16 AND the date in cell B1 is after 07/...