Excel Forum
-
Calculation of positions in excel Solved/Closed
Hello Hello, sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...
-
Data Validation refers to Sheet Name Closed
Hello, I would like to request for solving my problem My workbook contains many sheets, some ends with the "-E" (Hyphen Symbol and Alphabet E) S...
-
insert filename.csv into the *.csv file Closed
Hi Trowa I'm having 3000 files in *.csv format. I want to insert filename.csv into the *.csv file of 'A' column. Is it possible? I'm unable to fin...
-
Excel Macro's copy data from one sheet to another Solved/Closed
Hey Everyone ok, so, I have a document with multiple sheets one of the sheets is a reporting sheet what i am trying to accomplish with not much l...
-
Seeking Help with a Formula Closed
Hello, First, thanks for taking the time to read this. I'm not great at this and not sure this will even work. Ok, here goes; In a certain cell I i...
-
Need Help with Formula Closed
Hello, I'm not great at this and not sure this will even work. Ok, here goes; In a certain cell I input manually a productivity number daily. On c...
-
Copying an adjacent cell text from another sheet, if cell exist Closed
Hello, I have 2 excel sheets with lists (+5000 rows) of unique parameter names (text) on each row starting from A2. Sheet 1 has only the param...
-
formula for copying figures onto another sheet when value is >0 Closed
Hello, I would like to create a formula that will only show figures from another sheet that are greater than 0. This is for an invoice template. T...
-
Excel Macro Closed
Hello, I am trying to create a macro that will insert 2 blank rows into an existing spreadsheet after each category. I want the second blank row t...
-
COMPLICATED EXCEL FORMULA Closed
Hello Friends, Can any one help me to sove my problem. I have two excel sheets . i want to comapre column A and B with other sheet and if both cell...
-
Macro Copy & Paste same Cells Down Closed
Hi all, First off, I'm new to macros so just a warning. I am currently working on a simulation, and trying to create a macro that will record th...
-
Copy from one sheet to another based on value Closed
Hello, I am a newby to excel macros but here goes. I have a sheet where raw data is being entered in rows called DATA (How original) :-) I have...
-
Compare two Excel Sheets which have Duplicate Values (Advanced) Closed
Hello, I'm trying to compare two excel sheets which have duplicate values in the matching column. In both sheets the number of row count is dif...
-
Fetching of data from number of other sheets to a master sheet Closed
Hello, respected consultant, I have created a Excel Sheet for student class attendance. in it i have made a provision for over all attendance of ...
-
Cut-Paste from 1 Workbook to another-based on cell - del columns Closed
I have a master workbook and a template workbook. Master workbook has 6 col - Vendor / Rep / ST / Code / Amount / Name. Template has 5 col - Vendor ...
-
Moving Entire row from one sheet to another Closed
Hey, I have a list of job orders listed in excel. One job takes one row. One of the columns reads heading as "Job status", the value under job status...
-
Urgent Copy Vertical data from One sheet to another horizontally Closed
Hello, I am trying to copy cell data from one sheet to another, the data in source sheet is vertical and i have to copy horizontally in destination...
-
Pictures pasting over each other....Help Closed
Credits to TrowaD in this Forum I was able to use his VBA Code for what I wanted but it just need a touch more to make it complete....The code below p...
-
Get a value from Col A based on the max value found in Col B Solved/Closed
Hello, Get a value from Column A based on the max value found in Column B display in Column C. I need to get value Jill in Column C. Name A...
-
From iPhone to excel Closed
I need a button in excel where I could import I photo I am taking into an assigned cell. I will need to do this multiple times in a spreadsheet. Is t...
-
Check Options in Excel Closed
Hello, I would like to request that Questionnaire is design in which (ranges from A5 to E1000) Column B Contain Excellent Column C Contain Good...
-
Format cell's currency Closed
Hello, I am working with a drop down list that includes 7 or 8 account numbers to choose from through data validation. Various bills are paid from...
-
Comparing dates in multiple columns and using one that matches Solved/Closed
Hello, I have a table with multiple columns of date values and need to check whether a date in a certain column is less than that date and depende...
-
how to convert date into words(marathi) Closed
Hello, i want to know how to convert date into words(english) in excel 2003 or 2007 for eg. 22.04.2010 - convert it into Twenty Two April 2010 o...
-
Macro to insert a number into cell A11 for 180+ excel files? Solved/Closed
I used the macro below to merge a bunch of files but it cut off the last row of data. It looks for the first A cell with nothing in it to end it and t...
-
Auto populate into a different tab based on cell value Closed
Hello, My job involves tracking several POs for several different vendors. I am looking to compile several sheets of data into one workbook with d...
-
Column Matching and Data Pulling Closed
Hello, I am looking for first, for two columns to match, let's call them A and C, if they match, I want Column D to have the same vaule as Column ...
-
Create & name worksheets from a list and copy data Solved/Closed
Hi Guys Really new to this and thanks to previous posts on here I have managed to create code to complete the first part of my jigsaw, just struggl...
-
Copying data with respect to a condition Closed
Hello all, I suppose the problem I have is not a complex one. Here is a brief intro to my work sheet A B C D ...
-
copying specific range of datas Closed
Hello, I suppose the problem I have is not a complex one. Here is a brief intro to my work sheet A B C D E F ...
-
How to write a macro to lookup rows Closed
Hi, i have 2 worksheets with hundreds of thousands of rows of cost centers. I would need to do a lookup of Cost Centers in worksheet 1 with workshe...
-
how to change to infilll colour of one cell according to another Closed
Hello, I am hoping some one can help me, I have started looking to set up a database regarding dates for training, it is dynamic changing the date a...
-
Macro - Create new sheet and generate information from Summary Closed
Hi all, Just wondering if someone can assist, I need to create a spreadsheet that has a running list of service calls (Summary) then once a line is...
-
VBA Macros Help Closed
Hello, I have a need to create a macro that is beyond my knowledge. I recently started trying to learn how to write simple macros in order to simp...
-
Multi Copying Excel 2013 Closed
Evening All I looking to copy the same lines of excel * so many times depending on number in a column. So anything input in A2,B2,C2,D2 is cop...
-
Help needed to compare excel worksheets. Closed
Hello, I have an Excel worksheet that contains a list of part numbers that I stock. I also have other worksheets that contain lists of parts that ...
-
Middle name extraction Closed
Hi, I need to extract middle name from full name. for some case its working but in those names without middle name, it throws #VALUE! error. also ...
-
Formatting whilst using letters and numbers Closed
I would like to conditionally format a spreadsheet based on grade progression, where the grade contains both a letter and number. The grades are n...
-
Conditional format make a row a color based on another cell Closed
Hi, I have a large spreadsheet with many rows and columns. I want to color a row green when we have been paid on that line. There is a column ...
-
How to insert columns until a cell condition is met Closed
Hi everyone. I'm not very good in macro and hope that anyone could give me some pointers. I have a worksheet (ie. Project A) whereby it contains he...
-
Paste data from specified cells to another when just typing comp Closed
Hello, Hello, I am trying to use macros to copy data from several cells into different cells in another sheet. My data is consisting of Organizati...
-
Macro to get random samples based on condition Closed
How to create a macro which picks random 200 rows from a excel file which has huge data. Each column containing both empty and valued data.
-
If cell contains a word from a word bank, then return value Closed
Hello, I need to be able to read a cell and see if it has any of the following word: John Jane Jake Jill Jack ect. Then return True on an...
-
Find the net elapsed time of a task Closed
Hello, I need to calculate the effective time taken by a task. I have the start date&time and end date&time of the task. Both the times are mai...
-
Macro-not refering correctly Closed
Hello, Iam very new to macro, i have written a code, that should work in sheet 6, but it always by defualt goes to sheet 1.Please find code below: ...
-
finding percentages Closed
Hello, I'm not sure if i'm asking my question in the right place or not. I need to find percentage of attendance for a period of time. I have...
-
Cell referrence Closed
Hello, How can we referrence a particular cell value in date formate in another cell which has a multiple number? Thanks
-
Lookup 2 cell headers one one sheet to find answer on another Closed
Hello, I am trying to lookup the employee name and week # included on sheet A on sheet B in order to find the % of utilization during that week. ...
-
Need only date from text Closed
Hello, how to get only date when a cell contains text. EX: MON 12/20/1968 12:30 . I want only the date 12/20/1968
-
Populating many sheets from one Closed
Issue: I'm working on a Google Excel doc which is being populated by entries on a Google form. Each row on the sheet relates to one form entry. ...
