Forum
- Popular discussions
-
How to specify macro for current active sheet [Solved/Closed]
Hello, this is a very basic question, I am sorry to ask. I have created a macro in excel that I want to run in the current worksheet that is...
-
Unable to change date format in Excel [Solved/Closed]
Hello, I have an excel worksheet with a date column, the format is set to dd-mmm-yyyy but the dates in the columns display as mm/dd/yyyy. If I...
-
If a cell contains any text then add a value [Solved/Closed]
I hope someone can help me with this...I've done this before but can't remember how. I have a list of names (for an attendees list) and I need...
-
Copying data from one Excel sheet to another. [Solved/Closed]
Hello, Newbie here. Okay, I have an Excel workbook that houses a form on the first sheet. What I'm trying to do is to automatically copy...
-
Excel - A macro to create new workbook and copy data [Solved/Closed]
In the example below, I want to copy Column A starting from row 2 ie: "Age" till the value available ie: "Code and column B starting from row 2...
- More »
-
Updating a sheet name in Excel without macros?
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...
-
transferdata from 1 sheet to other sheets criteria
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...
-
Auto Update a workbook with multiple sheets on one sheet of the same workbook.
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 ,...
-
Table Values used to auto calculate and return val
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...
-
VLookup formula gives error
=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...
-
How to repair xlsx Excel 2010 Microsoft file? [Closed]
Hello, How to repair xlsx Excel 2010 Microsoft file? I see a file with non-zero size but cannot open it. System Configuration: Windows /...
-
Copy data from one sheet to another
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...
-
Concatenate columns in Excel
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...
-
Pulling in missing data between spreadsheets
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...
-
Salary calculator in Excel
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...
-
Auto populate specific data from sheet to another
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...
-
Adding fields to formula at one time
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...
-
Excel date conditions
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...
-
How to insert pictures in Excel using Macro
Hi, I'm facing 2 issues in using below code. 1st, suppose the image names are in column B from B2 to B11. Now, if the image against the image...
-
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...
-
Copying non blank cells from one sheet to another
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...
-
Extract missing word from text string
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...
-
Excel autofilter stops filtering [Solved/Closed]
Hello, I am working with Excel 2003 professional and just yesterday after entering a bunch of records to my file which has about 19,000 rows I...
-
Change color for specific number of cells by value [Solved]
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....
-
Auto populate from master file to other [Solved]
Hi Good afternoon!! I have a master data file that comprises of data of overall activities of the project including sales,contract...
-
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...
-
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...
-
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...
-
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,...
-
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 ...
-
Auto create info sheets from master spreadsheet [Solved]
UPDATE: I am able to automatically generate the excel sheets and then automatically convert those sheets into separate files using a macro. My...
-
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...
-
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...
-
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...
-
How to specify macro for current active sheet [Solved/Closed]
Hello, this is a very basic question, I am sorry to ask. I have created a macro in excel that I want to run in the current worksheet that is...
-
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...
-
Unable to change date format in Excel [Solved/Closed]
Hello, I have an excel worksheet with a date column, the format is set to dd-mmm-yyyy but the dates in the columns display as mm/dd/yyyy. If I...
-
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.
-
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 ...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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]
Hello, I'm looking for example to use scripting.dictionary. on topic user Smallman1 https://ccm.net/forum/affich-947210-any-faster-version-of...
-
How to change date format from yyyymmdd to mm/dd/yy in Excel [Solved/Closed]
Hello, I have data with dates arranged thusly: yyyymmdd Is there an easy way to change the format to mm/dd/yy in Excel...
-
How can I automatically copy table to next sheet? [Solved]
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...
-
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,...
-
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...
-
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),...
-
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...
-
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...
-
Excel partial match [Solved]
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...