Excel Forum
-
Consolidate based on a value in Excel Closed
Hi All, I have 2 worksheets and i want to consolidate them into a third sheet based on the value of column P. If column P on either sheet (named...
-
Excel - Lookup Query... Closed
Hi, I'm trying to find something similar to this but I'm having trouble. Im no way an expert but I know my way around and basic functions.... ...
-
Convert data with rows into columns Closed
Hello, I wanted to convert huge amount of data with rows into columns , with few conditions please let me know if you can help. System...
-
Find Partial text Match Closed
Hi, Please help me with the function to highlight a partial text Matches in column with other column. For example Column A: SWDP9233 When a co...
-
Copy Single row from working file to Master file Closed
Hello Sir, I have one working file containing multiple rows, I have one other Master file with 2 tabs. I need to copy Single row from working file ...
-
macros Closed
how to convert multiple columns into rows with few conditions
-
How to recover a corrupt Excel file? Closed
how to recover corrupt excel file
-
Use in Scripting.Dictionary- item join string 3col Solved/Closed
Hello, 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/Closed
Hello, 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? Solved/Closed
Hello, 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...
-
Small business tracking in Excel Closed
I have not found a small business software that meets my needs, and have created a tabbed spreadsheet. However, it has become a bit cumbersome, and ...
-
Copy and paste spaces inbetween data into a range Closed
Hello, I have file of student registrations that arent exporting to excel to properly. So I decided to copy all the cells and paste it into excel....
-
Using VBA code to search and minus cell value Closed
Hello! I'm desperately trying to do a macro button that can lookup a table's column and row headers (from 2 lookup_values entered in 2 cells), then...
-
Required value as per the scanned data Closed
Hi Everyone, I use VLOOKUP on a very frequent basis for my day to day work. I have a sheet full of data of inventory while doing my stocks audi...
-
Change date format dd.mm.yyyy to dd/mm/yyyy Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 ...
-
Create a macro to open workbooks Closed
Hello, Please help me to create a macro which will help me to open different excel workbooks and copy particular data/ figures from excel sheets t...
-
How to create a macro to open different workbooks Closed
Hello, I have around 45-50 excel workbook with 3-5 sheets in each workbook. Each workbook is named as different unique number such as 823456,82...
-
Moving data to multiple sheets Closed
I have a spreadsheet that I want to enter data into a main location and then have it go to specific sheets based on state and date entered. My data i...
-
How to place and X in cell F7 Closed
Hello, I am in excel, I want to be able to place and X in cell F7 and have the time automatically be placed in cell G7. can someon please help me. T...
-
Applying conditional formatting rule to other rows Closed
I have a row with multiple cells. two cells have drop down lists. If the first cell has value "A" from the dropdownlist, and cell 2 has value "B" from...
-
Excel vba Closed
Hello, i want that the button do the next action automatically with one click in excel vba System Configuration: Windows / Firefox 59.0
-
Transfer data from 1 sheet to another with cond. Solved/Closed
Hi, 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 Solved/Closed
I 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...
-
Macro for inserting pictures from folder to Excel Closed
Hi guys I am new here and would appreciate any help for the following issue: I have an excel sheet with more than 100 product codes (e.g. 00501-016...
-
Find and replace from a dropdown Solved/Closed
hi 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...
-
DOB conversion in Excel Closed
Hello, how to do work DOB conversion in excel sheet System Configuration: Windows / Chrome 64.0.3282.186
-
How to easily cummulate data Solved/Closed
Hi 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...
-
VBA code to create Pivot Table Closed
Dear all, Attached and show below the xls sheet. I need help from the forum, once I click the button, a pivot table to be generated in a new s...
-
Change color of cell comparing contents to 2 cells Closed
Hello, Hope someone in this community can help me write a vba code to for example: Cells B3 and C3 have a value When I input values into cells r...
-
paste range of cells to next blank cell Closed
I have a fixed copy range of 11 cells that I need to paste to next blank cell in the same column to a list of 32000 tasks. please can you help with ma...
-
Pull data from sheet 1 to sheet 2 Closed
I would appreciate any help for my case. So in sheet 1 called WIP, consist of item descriptions (C1) and quantity to be build (D1). The item descripti...
-
Copy Paste in loop in loop Closed
Hi Trowa, I am new to Macro - but i have similar request to copy paste in 2 loops 1. copy a number times Sheet 1 Column 1 data ( say having 3 val...
-
Automatic Payroll Computation Closed
Hi everyone. Im just new to my job and one of the task assigned to me is to compute payroll for our employees. im not that knowledgable with excel, m...
-
VLookup plus and and or match Closed
Hello, I am trying to compare two different pulls from and HRIS system in Excel to create a monthly Delta file, I not only need to look up and r...
-
Automatically change the cell from general to date Closed
Hello, System Configuration: Windows / Chrome 64.0.3282.186 Somehow i am facing an issue again and again in my office 365 excel, when i sa...
-
copy text from one work sheet to another Closed
Hello, Could some one help explain how I can simply copy text from a cell in a different work sheet. I'm trying to make a report using the months of t...
-
If then formula Closed
Hello, I am working in excel 2016. I would like to use a formula in regards to days and a project time line. For instance if a project has 365 d...
-
How do you change cell colour based on date Closed
Hello, How do you change cell colour automatically based on date. I am trying to set my training spreadsheet so I can clearly see when staff membe...
-
Repetitive formulae Closed
Hello, how do I construct multiple pages with the same set of formulas? System Configuration: Windows / Internet Explorer 11.0
-
How to copy information from sheet 2 into sheet1 Closed
I have a spread sheet with two sheets. The first contains names and i need to copy information from sheet 2 into sheet1. in Sheet 1 F66 =Sheet2 A2 ...
-
How to cell in sheet 1 into another calendar sheet Closed
Hello, Elson here. Would like to ask. How to transfer a date + remark from sheet A, into a calendar sheet B. For example. Sheet A Cell 1: date (...
-
Salary difference from two years based in employee Closed
Hello, Hi sir/ madam I have two sheets and in one sheet consists of 2007 year employees details ( I'd and salary) and second sheet also consists ...
-
Assistance request - IF statement and adding Time Closed
Hello Friends, I would be extremely greatfull if someone would have the time to assist me with a formula in Excel. I also know this is a voluntary...
-
Insert multiple copied rows at fixed intervals Closed
Helo Would you please help me by giving Solution for my Question how I can insert multiple copied rows n time at fixed interval using excel macros ...
-
IF statement and adding Military Time Question Closed
Hello, I am trying to add time inside an IF statement, but I cannot get the time to show correctly when adding more than 30 mins. Here is my f...
-
Find a value in a matrix array Closed
Hello, Is there any formula to find a value in a matrix array A program in gw basic i want to change it into excel. Suppose A B ...
-
School report card with data of all classes Closed
dear sir/madam i am looking for excel work for school report card, one sheet where i want to put data as where data will be entry(sheet-1) class...
-
Moving Rows overflow from Cols A&B to C&D help Closed
Hello, I'm new to this macro business but I was able to create a sheet that functions 95% of how I want it to. My only problem now is that my shee...
-
Insert the number 001 in column A if B A00-A10 Closed
Hello, In column B the data range from A00-Z99 and I want to insert the number 001 in column A if B A00-A10 and 002 if columnB A11-A20 which f...
