Excel Forum
-
Copy data from 1 workbook to another based on sheet tabs [Solved/Closed]
Good day to all, I'm looking for a macro that can copy data from source workbook and paste it to master workbook based on specified sheet tabs. ...
-
problems with transfering/capturing data [Closed]
Hello, I have an excel sheet with tones of information on for my customer I want to capture savings made and automatically transfer the date ont...
-
Macro for selective copying [Closed]
Hi Guys, I currently have a tonne of data that is dumped in a sheet called Unsorted Raw Data. I would like to create a macro that allows me to co...
-
Match requests sent to bank with requests processed by bank [Closed]
Hello, I am trying to match the requests processed by the bank with the requests sent to the bank for processing. The bank could process part of ...
-
Copy data automatically to enter into calendar sheet [Closed]
Hello, I have 2 sheets. 1 sheet contains calendar months along one axis, and different positions (jobs) along the other the axis. My 2nd sheet co...
-
How to return a cell value from a sheet that is not created yet? [Closed]
Hello, I am creating a job summary sheet to collect data from sheets that will be created based on each day worked on a project. I've created a...
-
Creating sheet with list having duplicate values. [Closed]
Hello, I have a list in a column need to create sheets with each value in the list. The list will have duplicate values. but excel cannot have two s...
-
Hide Page Breaks in Excel 2010 [Closed]
Hello, Is it possible to hide page breaks in excel while shifting from print preview to normal view using vba? I know to remove pages breaks ...
-
Link data from one cell to another [Solved/Closed]
Hello, ok now what I am trying to do is make a simple formula that will let me take some data out of work book a and have it appear in work book B. ...
-
Excel:Print one enlarged page to multiple pages [Solved/Closed]
Hello, Is it possible to print a enlarged page to multiple pages in excel? Configuration: Windows / Chrome 45.0.2454.101
-
Master Sheet Data [Closed]
I have a master sheet on Excel with inventory of uniforms and who is assigned to each piece of uniform, ex: Gordon has #4 hat, #22 coat and #88 pant. ...
-
want to add new colom if a text is found in a cell range [Closed]
Hello Everybody, As shown in attached fig. I want to write in foundIn colom if a text in authors colom is present in Publications colom. If it is fo...
-
Inputting a text based on another column Text. [Closed]
Hi, Hope all is well. I was wondering if you can help. I cannot figure out the formula to automatically add text to one cell base on another c...
-
Range formula [Closed]
Dear all In MS excel column B is names of more than 100 staffs,column A is date of payment, column C is bill No (RA No 1-20), column D is amount bi...
-
Macro or help with populating data after inputting [Closed]
I would like to be able to enter information into the sheet shown daily (therefore every day different and new data will be inputted into this main sh...
-
Excel /VBA - Copy data from one work book to another [Closed]
Hello All, Can you please help me to make VB program for an excel file. Basically I want to copy the data from an excel work book which is located...
-
Entering current time in specific cells [Solved/Closed]
Hi, I am using a workbook where I record the time that I give each of my students an exam. I am using a tablet and I would like to be able to touch (o...
-
excel dynamic matching [Closed]
hiya, i have three sheets: sheet 1 - detail is input manually someone's name and personal details sheet 2 - a sheet that takes some detail f...
-
Count the number of days from start date to end date [Closed]
Hello, I want to count the number of days from start date to end date. ie. 1/2/15 - 1/4/15 is 3 days.
-
Need help with formula [Closed]
I am needing some help with a formula...if possible. I have numbers from 1-85 listed in column F. These numbers can appear multiple times. I have a v...
-
Finding multiple doc cases that do NOT have a specific document [Closed]
Thank you for letting me post here. My question: I have several thousand case files, a different one for each of several thousand clients. There...
-
calculating the positions of my students [Closed]
hi i need help in calculating the positions of my students after having calculated their total marks
-
show the duplicate values for each party name [Closed]
I want to show the duplicate values for each party name. Kindly help
-
How to transfer info from one column to another [Closed]
I have approximately 650 names in Column A. Column B is blank. Column C contains 3400 names. Column D contains information about Column C. All of the ...
-
On Cell change event vba [Closed]
Hello Folks, I m trying to get hold of on cell change event vba code, if the cell value is changed to blank or zero. otherwise i have code which tr...
-
Comparing Two Columns With other two columns in excel 2003 [Solved/Closed]
Dear Sir, I want to compare two columns with other two columns in excel 2003. Columns are as below A B C D a 10 a 10 b 20 b 30 c 30 d 40 ...
-
Excel - shortcut key for print view [Solved/Closed]
Hello, I am srinu what is d short cut key in ex-cel 2003 for print viewConfiguration: Windows XP / Safari 532.5
-
Replacing an empty cell's contents [Closed]
I have some empty cells in "J" column which I want to replace with data from another cell which is in "X" column. The formula has to be in "AA" column...
-
Populate Data from 1 Sheet to Multiple Sheet in Master Workbook [Closed]
Hi, Source workbook is where the data is maintained and from where the macro will be run. Master workbook has 40 sheets and I want the macro to ...
-
Please assist with an If formula referencing 2 cells [Closed]
Good evening, I was hoping if someone could please assist with in creating an if statement to utilise in a training register. I have a dropdown men...
-
create worksheets with names from a list [Solved/Closed]
Hello, I would be most grateful if you would kindly help me out. I have a long list of projects and need to create an individual worksheet for ea...
-
Finding terms in one word sheet & display on another word sheet [Closed]
I have two work sheets: Projects sheet that lists clients and the services we provided: A B C D ...
-
calculate percentage in excel [Closed]
Hello, My question is how to calculate 495000 kg main item scrap only 8 kg how to calculate in % figure
-
R, moving every other value in a column to a second column [Closed]
Hello, I have been tasked with manipulating the data ina a vector of 900 values in a form of a column. Every two values signifies a lenght and weig...
-
Integers in multiple rows to single row [Closed]
Hello all, My data set is like as follows: (All integers) ROW 1: 1 2 3 4 5 6 7 8 9 10 11 12 13...to 26 (26 cells) ROW 2: 27 28 29 30...52 (26...
-
Copy a set of cells and paste it 430 times [Closed]
Hello, In excel i need to copy set of cells and paste down 430 times. Any suggestions. Regards, Arunmaran
-
Keep track of hours [Closed]
Hello, I have a list of people and how many hours they have missed from work. Is there a way to sync this every day with the new data which might ha...
-
Get Mirrored Column "Structure" in 2 Sheets [Closed]
So this turned out to be a complete mind-breaker for me. Thanks to the help I previously received on this forum I can already manage (and enjoy!) q...
-
Help Please IF & VLOOKUP Returns [Closed]
Hi, I'm trying to use the following formula which works however I can have more than one number which is the same e.g( B2 can be in the TOPWE tabl...
-
Transfer, populate and calculate data between excel sheets. [Closed]
Hello, I want to be able to input data daily onto the first sheet of my excel file for six different things. I then want to have a separate sh...
-
incrementing the column at regular intervals [Closed]
Hello, I need to increase the cell range at regular intervals using macros. My code is: Do While Cells(2, m).Value "" Range("cells(2,...
-
Hide Zero Rows or Zero Columns in a Worksheet [Closed]
Hello, I would like to know if there is VB code out there that solves for Hiding rows and Columns that show either zeros across the rows or the ...
-
Excel - Merge several worksheets into a single one(thanks) [Closed]
Hello, I use Excel to store information about several users and their cars information and have a different worksheet for each month. How to merge...
-
How to filter out data to separate sheet? [Closed]
Hello Guys, Can someone pls help me out with this problem I am having. I have 5 drivers on payroll for a car service company. I have all the a...
-
file attachment [Solved/Closed]
Hello, is it possible to attach an excel file in this forum, for a better understanding of a particular posed question? Configuration: Windows ...
-
check info on two different cells... [Solved/Closed]
Hello, Ladies, Gentlemen, I am working with the formula below, and it WORKS GREAT =IF(Z17="PAID","",IF(F17"CTF","",IF(TODAY()>B17+15,"PAY NOW","HOLD...
-
Disable right click on sheet tabs in excel (MAC) using VBA code [Closed]
Hello, I am looking for a VBA code to disable right click on worksheet tabs in MAC excel. Application.commandbars("Ply").enabled=false is not ...
-
How to restrict user from deleting a sheet? [Closed]
Hello, I want to restrict the user from deleting a sheet using vba code. I dont want to protect the sheet. Is there any option to protect the s...
-
Macro auto run on file creation. [Closed]
Hello, I have an excel file created automatically every day, I want to be able to run a macro against the file when it's opened. I can automat...
-
Write data if a text is found in that colomn [Closed]
I want to write some value if A text String in Cell A is present in another colom and if found then I want to write the value of that row in front of ...
