Excel Forum
-
Failing to sign in to excel [Closed]
hie can you be of assistance im failing to sign in to excel it keeps telling me that there is a problem with my account. i have tried resetting the pa...
-
Excel "IF" function w/ date in test cell [Solved/Closed]
Hello, 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...
-
Updating a sheet name in Excel without macros? [Closed]
Hey everyone, I've been working on a project and in order to do it how I was planning, I need to update sheet names dynamically without using macro...
-
calculate how many times member A visit the cafe [Closed]
Hello, member A register at cafe on a date 12 april 2017. He visited the cafe every times started from the registed date when the cafe opened at ...
-
transferdata from 1 sheet to other sheets criteria [Closed]
Greetings! I have been trying to look for vba codes and formulas but am still at a lost as to how to even start. Am a total newbie at this whole vb...
-
Auto Update a workbook with multiple sheets on one sheet of the same workbook. [Closed]
Good pm. I need your help in order to enable me carry out update in ms excel. I have a workbook with multiple sheets (namely, creche , nursery1, ...
-
Table Values used to auto calculate and return val [Closed]
Is there a way in a formula to have Excel continually look in a table, and insert a value in a cell , so that the value in another cell will never be ...
-
VLookup formula gives error [Closed]
=VLOOKUP(A29,'I:\Vending Reports\2018\3. March 2018\[March 2018.xlsm]Crews'!$A$1:$H$370,8,FALSE)+G29 This is my formula. It is supposed to look f...
-
Copy data from one sheet to another [Closed]
How can I copy data from one sheet to another on the basis of value in cell G10, say if value is DELHI then set of column corresponding to delhi will ...
-
Concatenate columns in Excel [Closed]
Hey actually i have a prob, i have 4 columns in my excel sheet, among them based on 2nd column i have to concatenate the contents of 4th column...
-
Pulling in missing data between spreadsheets [Closed]
I receive a spreadsheet every week that has a list of IP addresses of servers that need updates. Not all servers need updates every week so this sprea...
-
Salary calculator in Excel [Closed]
I want to make a salary calculator( in excel ) in which I want to add 3% increment in "basic". My columns are :---- 1. "Month"=march 2017, April 2017 ...
-
Auto populate specific data from sheet to another [Closed]
Hello, I'm trying to auto populate data from one workbook to another, or sheets if that makes it easier. In the sample I've included I'm trying to...
-
Adding fields to formula at one time [Closed]
Hi guys, Not sure if there's a quick way for this: Do you know if possible to do this: Sheet 1 A1 field contains formula: sheet 2 A1 plus sheet 3 ...
-
Excel date conditions [Closed]
I have to go in every 2 weeks to update a spreadsheet, based on whether the date in the row is current or in the past. Is there a way to set it up s...
-
Leaving a Copied Cell Blank if no data [Closed]
I have several spreadsheets containing different information on the same patient. Patient is ID a number. The ID has to copy over to several different...
-
Copying non blank cells from one sheet to another [Closed]
Hi all I have some code here that works great but I am looking at adding in some additions. I am currently struggling and I hope that maybe someone on...
-
Extract missing word from text string [Closed]
Hello, Hello, i have data in 2 columns, for ex: Column A: Bearing, Ball, 1/2 in, Cast Iron Column B: Bearing, Ball, Cast Iron by s...
-
Change color for specific number of cells by value [Solved/Closed]
I 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 [Solved/Closed]
Hi Good afternoon!! I have a master data file that comprises of data of overall activities of the project including sales,contract value, wo...
-
VBA Copying cells based on if there is a value [Closed]
I have this code which works great thanks to help I received here. I am looking to see if it is even possible to add in some addition functionality. C...
-
VBA Copy data based on count result [Closed]
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...
-
Top 10 in descending order [Closed]
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 [Closed]
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 [Closed]
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 [Solved/Closed]
UPDATE: 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 [Closed]
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...
-
Autopopulating data from master excel sheet [Closed]
Hi, I have a master sheet where column A, B, C etc. resides username, password, application etc. information. Now I have created a report which ...
-
Query on developing table and chart automatically [Closed]
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 ...
-
Automatically move data from one sheet [Closed]
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 ...
-
Conditional Formatting [Closed]
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.
-
Copy data from one Workbook to another [Closed]
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 [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...
Subscribe To Our Newsletter!
