Excel Forum
-
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...
-
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...
-
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...
-
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 [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...
-
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...
-
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....
-
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...
-
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 [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...
-
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...
-
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,...
-
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 ...
-
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...
-
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...
-
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 [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...
-
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...
-
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 ...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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,...
-
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...
-
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),...
-
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...
-
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/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...
-
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...
-
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...
-
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...
-
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...
-
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"...
-
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...
-
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...
-
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...
-
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...
-
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,...
-
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...
-
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...
