vcoolio 203

Moderator
Registration date
July 24, 2014
Last seen
August 17, 2019
Contributions
1,249

Hello, I am keeping track of how many work orders are being created each month. On my "Completed Sheet" in column F it has the due dates. I would like to figure out how to calculate that column and create how many wokr orders are completed each month and put into a bar graph to represent it. I also would like it placed on a different ... Read more

Code to move rows into another sheet based on certain values [Solved]

Hello, I'm having trouble figuring out how to do something! I have a sheet (Design) with work order details on it (columns A-J will have data in). I want to be able to write "100%" in column G of the row in particular if the customer's contract has been completed and this cause the entire row to be cut and pasted into the completed she... Read more

Copy rows to other sheets based on value in column [Solved]

Hello, I have copy and pasted the code used to solve the problem for the question which began this thread. I have 6 tabs into which I want to copy data based on inputs in column E. I have named my tabs, but I can't see that this should be a problem. code is below and data Sub TransferData() Dim ar As Variant ... Read more

Copy Template, Rename based on a reference list from a different spreadsheet

Hello: I am trying to make copies of a template in a worksheet, and rename those worksheets from a list on a separate worksheet. Currently my template sheet is what I want to copy. The number of copies will be based on a list of dates on a separate worksheet within the same workbook. For instance, I need to copy my template (worksh... Read more

Replace 'sheet' reference in a formula (not copy data, but get averages) [Solved]

Hello, I'm working with a precipitation data base of multiple sheets. Each sheet is a year of measurements. The thing is that I'm trying to get the average of several municipalities for each year. Is there a way I can automatically replace the 'sheet' in the formula so I don't have to change it manually? Example: =AVERAGE('1996... Read more

Formula to subtract one cell value from another.

Hello, I am trying to do a formula that would subtract cell a2 from a1 if cell a3 has "Closed" in it. Is this possible?

1
Thanks

Automatically copy data from main sheet to child sheets. [Solved]

Hello, I know this question was asked in another thread (https://ccm.net/forum/affich-800808-need-to-automatically-copy-data-from-one-sheet-to-another), however, the thread was closed and I had additional questions... I have a spreadsheet that I am updating for a coworker and trying to make it as automated as possible for minimal ... Read more

Updating other Excel sheets automatically from Master sheet.

Hi, I have been trying to sort this for a while. I have entered data in my master sheet and I have 4 other sheets. When I put new data into the master sheet I want the other sheets to automatically update, can anyone help me?

Pulling data from multiple sheets to master sheet

Hello, I am working on a project and I could definitely use some help. I have an excel file with four sheets: Master Sheet, Project A, Project B, Project C. Each project has a table with a list of various tasks. Each task has a variety of fields such as: Title, Name, Date, Status and Description. Within the status drop down, I... Read more

Copy rows n times in Excel [Solved]

Hello, I Need to copy from rows from A1:AY39 and need to insert in A41 and the same as be pasted on next 38 Row from A41 and it as to be done for 50 Times Kindly Provide Solution ASAP

Master sheet and connecting other sheets

I am trying to make a master list of all my donors for charity. The master list will have less information on it then the following sheets. Bellow are the categories for the master. Then on the separate sheets I will have more information and notes about each company. Category Company Name Contact Name Phone Email Website Donate... Read more

Populate separate worksheets with data from main worksheet based on criteria met [Solved]

Hello, I'm making an accounting workbook and I've run into a problem. On the first sheet "Sales Log" I input all of the transactions that the company does on a table that goes from B10-i10, and on down for every entry. One of the columns in the table is labeled "Room" and refers to which Sales room the revenue came from. There ar... Read more

1
Thanks