The discussions
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...
Vba copy data based on count result
Hi, I am trying to build in the following code in order to count how many cells in a row have data. Based on the count I then need to Copy cells by t...
Microsoft office and home page
i cant find my microsoft office that i have downloaded
Top 10 in descending order
Hi guys, I'm struggling to find a solution for this. There is a list that contains, time-frame as Q12016 up until Q42018, then cities as London, Pa...
Autopopulating data from master excel to new excel
Hello All, I am stuck with a problem and would appreciate if someone can help me. Here my question. I have a master sheet where column A, B, C e...
Copy data in one worksheet to another vba
Hi all, I am trying very hard with little success to automate this with VBA. I am trying to copy data from Sheet1 Row1 in Column A, B & C and t...
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...
Formula that will adjust dates based on a change
what formula can i use so that the days (mondays-sundays) will automalticaly adjust when im changing the date (March 12, 2018)? It's for the DTR (dail...
How to convert numbers into words
Hello Sir, Is it possible to make the words within brackets? System Configuration: Windows / Chrome 65.0.3325.181
Query on developing table and chart automatically
Hello, Please guide me how to develop a table & chart automatically based on the below input data. I am able to develop table and chart manually ...
Excel cell value on a slide
Hii, I want to display on a slide the variable value calculated on an excel sheet. This sheet contains value used for a graph. Thanks in advan...
Automatically move data from one sheet
How to automatically move/copy data from one sheet to another if certain criteria met. Hi. I have two sheets, sheet1 I have data where each cell has ...
Microsft word icon is gone.
Solved/ClosedHello, I have a question. Until recently there has been a Micorosft icon on my desktop and it showed up under the "All Programs" list on my Start ...
Conditional formatting
I have cell G8 in excel which is a time stamp. I want it to be highlighted when it is greater than cell A8 which is a scheduled time.
Convert pdf to word without altering pdf images
Solved/ClosedCan converting from PDF to word be done without alterations of the PDF images?
Copy data from one workbook to another
Hello, I have to save data from one Sheet 1 of Workbook 1 to Sheet 1 of workbook two. EX: Sheet 1, Workbook 1 Date Name Salary 1/1 ABC 100...
Consolidate based on a value in excel
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...
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.... ...
What is product key for ms office 2010
Kindly tell the Product Key For MS OFFICE 2010
Convert data with rows into columns
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
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
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 ...
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...
Small business tracking in excel
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
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
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
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/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 ...
Create a macro to open workbooks
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...
Moving data to multiple sheets
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
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...
Convert number to spelling
Solved/ClosedHello, I Can change the Number into Spell but the problem is it does not convert in Indian Rupees. Present Situation =SpellNumber(58.20) = Fifty ...
Applying conditional formatting rule to other rows
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...
How to transform .ost in .pst ?
ClosedWe need an easy way to transform . OST in . PST ? What is the easiest way to do this? I just need to work with e-mail now, and I don't have such an op...
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...
Macro for inserting pictures from folder to excel
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
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...
Dob conversion in excel
Hello, how to do work DOB conversion in excel sheet System Configuration: Windows / Chrome 64.0.3282.186
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...
Vba code to create pivot table
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
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...
Pull data from sheet 1 to sheet 2
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
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
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...
Counter/animation
Hello, I have quite a unique question regarding powerpoint. I'm wondering if it can be done. I wish to make a marking scheme on powerpoint say for ...
