Registration date
July 24, 2014
Last seen
September 29, 2019
Contributions
1,251

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

I'm having trouble figuring out how to do something! I have a sheet (Sheet1) with customer details on it (columns A-D will have data in). I want to be able to write "Cancelled" in column E of the row in particular if the customer's contract has been cancelled and this cause the entire row to be cut and pasted into Sheet2 which will be for... Read more

Macro to Create New Workbook and Copy Data at Each Change of X

Hello, I get large spreadsheets with thousands of lines with close to 200 patient names (one patient contains multiple lines for each different date of service). Is there a macro that can be written to create a new workbook at each change in PATIENT_NAME that will also keep the first row with the column headers on each workbook? The... Read more

Creating Graph that updates

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

Use of '@' in formulae [Solved]

Hi, I have received a spreadsheet with cells in column E containing the following formula [@[Retail Price]]/[@[Pack Size]]*100 Where the "Retail Price" and "Pack Size" are headings for columns C and D. That formula is repeated exactly in all cells in column E and it does the calculation for each row based on the content of the ... Read more

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

All, I have an Excel file with three sheets: Sheet1 contains all my data. Sheet2 named "MACH" and Sheet3 named "FAB" I am looking for a way with a macro, to run upon opening the Excel document, and look in column "G" of Sheet1 for the values "MACH" and "FAB. If "MACH" is found in "G" then it copies the row into the sheet named "MACH" ... Read more

Use of '@' in formulae [Solved]

Hi, I have received a spreadsheet with cells in column E containing the following formula [@[Retail Price]]/[@[Pack Size]]*100 Where the "Retail Price" and "Pack Size" are headings for columns C and D. That formula is repeated exactly in all cells in column E and it does the calculation for each row based on the content of the ... Read more

Create new sheets based on Column A data. [Solved]

Hi, Is there a way to create a new tab based on column A? For example: I want to create a new tab for each vehicle, copy and paste all of vehicle 722's columnA to Column F cells then move on to create a new tab for 725 and copy and paste all 725's Column A to F to the new tab. if the macro can also name the tab name as vehicle number ... 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

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

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?

Excel - A macro to rename existing worksheets based on a list [Solved]

I have a P.O. spreadsheet with a summary page. Every year we need to create a new file but I would like to create a template that would just renumber the spreadsheets based on whatever number we finished at the previous year. Sub CreateSheetsFromAList() Dim MyCell As Range, MyRange As Range Set MyRange = Sheets("Sum... Read more

vba copy data from a range and paste to empty column

Hello, I have a set of values in range P6:P15. At the end of each month, I would like to copy and paste the data from the current month column to the next empty column on the right until all 12 months are filled up. For example, at the end of Jan when I run the macro it will copy the data from cells P6:P15 to the Jan column, and at t... Read more

vba copy data from a range and paste to empty column

Hello, I have a set of values in range P6:P15. At the end of each month, I would like to copy and paste the data from the current month column to the next empty column on the right until all 12 months are filled up. For example, at the end of Jan when I run the macro it will copy the data from cells P6:P15 to the Jan column, and at t... 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

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

VBA command button [Solved]

Hi Everyone, I need help creating the following: I want to create a CommandButton that when clicked it will check column "CB" for "YES" and will input on a different worksheet called "Update Report" what is in columns "A, B, D, AO, BF, BG" I would really appreciate the help! Thanks, Sergio Read more

VBA command button [Solved]

Hi Everyone, I need help creating the following: I want to create a CommandButton that when clicked it will check column "CB" for "YES" and will input on a different worksheet called "Update Report" what is in columns "A, B, D, AO, BF, BG" I would really appreciate the help! Thanks, Sergio Read more