The discussions
Problem with copy in one sheet
Solved/ClosedHello, There is a table on sheet1 for example. A B C D E 1 2 3 4 5 In cell A1 I drag the data from sheet2 cell A10 In cell A2 I drag t...
I need vba that creates a new sheet for every data entered in column d
SolvedHi, I need a formula that create a new sheet for every data in "D" column cells and sheet name is like the cell ,also add that cell whole row data ...
Budgeting forumla in excel
Solved/ClosedHi! So I'm trying to write a budget for my household. Payments are made from different accounts. I've included an example. If anything in Colu...
Copy rows n times in excel
SolvedHello, I Need to copy from rows from A1:AY39 and need to insert in A41 and the same as be pasted on next 38 Row from A41 and it as to be done for ...
Vba to compare column e from 2 sheets and copy entire row to sheet 3
SolvedHello, I have a worksheet where I want to compare values from sheet 1 and sheet 2 and if values in column E (both sheets) are the same to then co...
Excel formula to track accrued vacation
SolvedHello, I need help writing a formula in excel to track accrued vacation / personal time. During our employees first year of employment they earn P...
Copy rows based on a condition
SolvedHi How can I have excel copy the entire row of data from worksheet Employee Inventory to another worksheet called EEs if column Q contains TERM. I...
How to merge data from different excels
SolvedHello, My name is samar. I have a master sheet which cakculates all oaraneters for my team . To calculate this some raw data is needed . I had...
Recalculation of dates
SolvedHello, Hello, I'm trying to write a formula that will recalculate a date based on a fixed number of days. For example I have 2/1/19 in cell A42...
Populate separate worksheets with data from main worksheet based on criteria met
SolvedHello, I'm making an accounting workbook and I've run into a problem. On the first sheet "Sales Log" I input all of the transactions that the...
Paste value on filtered cells
SolvedHello, i was trying to "pasted value" on a filtered cell. but it seems to be pasting it to all cells... im using a "=concatenate" on several cell...
Comparing two columns using partial match logic
Solved/ClosedI need a bit of help please. I have 2 columns of data that I am doing a partial match compare (first 15 positions) using a formula in column AA. ...
Copy rows to rows on another worksheet if " ✔ "
SolvedHi everyone, Ultimate greenhorn here. I have just recently discovered the " Conditional Formatting " as well as VBA function on excel a week ago and...
Vba command button
SolvedHi Everyone, I need help creating the following: I want to create a CommandButton that when clicked it will check column "CB" for "YES" and will...
Count total quantity by date into month
SolvedHello, Good Day~ Kindly help to correct the formula for below, I had wrote a formula that to calculate the quantity by month to the order date ...
Saving multiple excel files based on a list
SolvedHi, I'm totally new to writing macros in excel but I thought I'd give it a go. I've seen similar threads but I can't find the answer to my problem....
Difference between delete and clear
SolvedCould some one explain both function ("Delete" and "Clear" in Excel) ?
If a column has a value add to another column?
SolvedHeya, i hope someone can help me with this. I currently have a very large formula sheet made up so i can input a value and add it too my total along w...
Macro to copy / paste cell text down various rows
SolvedHello, I have an enormous list sent to me of subcontractors who work for different companies and each employee is listed alphabetically within their...
Macro submit data drop to next row upon submission
SolvedHello, I am currently working on an Excel workbook that allows for a user to input specific information pertaining to WIP product, click the comma...
Recalculation
SolvedHi friends I need your help to do an operation. I have a worksheet that I calculate with f9 key.L18 cell is "OK" or "CHANGE" depending on 20 cells. ...
Making my macro independent on future sheets
SolvedHello All; 1st time posting anything so please bear with me. I really need some help and have going out of my mind for days with what I believe is...
Making formulas work, which work on other computer
SolvedHello, My boss is using a large spreadsheet with multiply formulas in and has been using it for quite a while, updating the figures as and when ne...
Multiple if statements in excel
SolvedHello, I am trying to calculate a cell based on values , so if A1 =between 1 to 10 than it will equal 10.00 if A1 = between 11 to 20 that it e...
Highlighting future dates
SolvedHi I have been tasked with building an excel spreadsheet for all staff training. I have managed to highlight cells where the date has expired, but...
Copy rows to other sheets based on value in column
SolvedHello, I have worked through this topic and the have modified the code for my worksheet, but I am having a problem with the F5 function. It works...
Make userform
Solved/ClosedHello, I need to make a userform and list all sheet names and for each sheet name i need all named ranges from book. Is that possible? Thanks in ad...
Vba code for copy & paste items for multiple times
SolvedHi, I'm a very beginner in VBA and would need this problem solved urgently. I'd like to copy each line item and paste them in a new sheet 9 times. I t...
Create sheets for additions to list on sheet one.
SolvedI have a running list of names in a workbook that are kept in alphabetical order on sheet one. Those names are updated daily with new additions. Eac...
Overwriting data during transfer
SolvedSir, I had created vba code to transfer data from one workbook to another. it's working 1st time . but second time when I'm tapping the command butt...
Vba code for command button
Solved/Closedhello everyone, i had created a macro enabled workbook (abc123.xlsm)which holds about 10 user forms and every user form complies data to separate wo...
When the field is =n, want to subtract that field
SolvedHello, This formula works, but when the field is =N, I want to subtract that field. What could I add to this formula to make that work? =(COUN...
Conditional formatting across multiple columns
SolvedHi there, I have two columns which if equal(unless blank), I wish to fill in with a colour. I have defined the range as the two columns(BX3:BY3) an...
Copy conditional formatting for an entire row based on one cell
Solved/ClosedHello. I'm working on an Excel sheet, where the entire row is colored based on the values of two cells in the current row. If one of the cells in t...
Duplicate rows from multiple worksheets
SolvedHello, I have a workbook that I'm hoping will be the template for a monthly log. It is almost done, but I cannot figure out the best way to perfor...
Excel "if" function w/ date in test cell
Solved/ClosedHello, I am trying to use the IF function with a date in the logic test cell; If the logice test cell has a date then I want the word "DONE" to sho...
Change color for specific number of cells by value
SolvedI have a excel sheet with data of planned and pending projects. In column "I" it states number of weeks required for completion of the project. Each r...
Auto populate from master file to other
SolvedHi Good afternoon!! I have a master data file that comprises of data of overall activities of the project including sales,contract value, wo...
Auto create info sheets from master spreadsheet
SolvedUPDATE: I am able to automatically generate the excel sheets and then automatically convert those sheets into separate files using a macro. My remaini...
Use in scripting.dictionary- item join string 3col
SolvedHello, I'm looking for example to use scripting.dictionary. on topic user Smallman1 https://ccm.net/forum/affich-947210-any-faster-version-of-the-sa...
How to change date format from yyyymmdd to mm/dd/yy in excel?
Solved/ClosedHello, I have data with dates arranged in yyyymmdd format. Is there an easy way to change the format to mm/dd/yy in Excel 2010? Thanks!
How can i automatically copy table to next sheet?
SolvedHello, I have an Excel file with 30 sheets containing the same table. In the table, the last column is a Yes/No (using data validation). Once a d...
Change date format dd.mm.yyyy to dd/mm/yyyy
Solved/ClosedHello, I Want to change date format dd.mm.yyyy to dd/mm/yyyy in MS Excel 2003 Please solve my problem urgently Shatrughna System Configuratio...
Excel partial match
SolvedHello, Hello, I have a small query related to Excel Search function. Suppose I need to search the below data in target cell which has some ...
Transfer data from 1 sheet to another with cond.
SolvedHi, I am having trouble working out how I would code this using VBA: In Sheet 1 I have 2 rows. The first row is the title and then the second ro...
Macro to manipulate lines of text
SolvedI have data that is arranged as this in four columns x emailx nameofx 123 x emailx nameofx 4456 x emailx nameofx 67 y emaily nameofy 12 z email...
Find and replace from a dropdown
Solvedhi Guys, second and hopefully last question for now. Is there a way to the following: I have a dropdown list with names of tabs of the excel file...
How to easily cummulate data
SolvedHi there, I was wondering if you guys know how to do this: got 13 weeks, each week has a figure underneath it. Let's say week 1 has 1 under it, wee...
How to add 200 working days to a given date.
SolvedHello, Please I want to know how I can add 200 working days to a specific date to get a new date
Auto populate data between excel sheets
SolvedHave project management data that should be automated to populate from two Excel sheets to the desired Excel sheet. I was thinking that it could be A...
