Registration date
July 24, 2014
Last seen
September 29, 2019

Excel VBA Sorting Problem

Hello, This code is placing all the header names in the last row after sorting in descending order. Can you please help how to keep the position of column names fixed?

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

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

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?

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

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