separate sheets

We have an online form that populates to an Excel spreadsheet. We would like the rows to automatically copy to separate sheets (tabs) based on the information in column A. Column A will be co-workers' names and the sheets will allow them to view only their accounts in their own sheet (tab). Can...

Hi, all I'm a newbie one at using VBA Macro to simplify my excel files. I admit that I use VBA by copying VBA macro after using VBA record. However, I find some difficulties when trying to hide/unhide column using button, inserted from developer tab. In my files, I have 9 sheets, it could be...

Hello ~ I need some help with the following! I need to use a Radio Button in sheet1 to filter a list in excel in sheet2 and then output the results in sheet1. The options for the radio button will filter on sheet2 column B. So a user will select one of the three options (which is "Type")...

I am trying to determine and track my commission within specific date ranges. Example: If I sell a job today for $10,000, I will get paid 5% commission on the next paycheck, and then when the job is complete and paid, I will get another 5% commission. I would like to make both of those separate...

I have been searching and searching and cannot find what I need. I am only an intermediate user, so if I have to use a macro or something, please walk me thru it. I have a master Excel 2010 book with approx 30 columns from A thru AD And 130 rows. Column A is sorted by last name, with only 26...

Dear All, First of all thanks in advance..... I am new in the forum and macros also.... Need your help to provide a macro.... I have a an excel sheet with some data... there is a column let say "Location"...i want a macro that separate the data location wise to new sheets in the same workbook...

I have a workbook with payroll actuals data for all our managers to review and assure we are not making mistakes in our process and that we paid people the correct amounts. It is approximately 19MB large and is shared on a network drive that takes WAY too long to open. I want to: Export each...

Good day all, I'm currently struggling with this conundrum...I need to transfer a figure from the end of a Row based on two criteria, column J= "1" & column O="Manufacturing, all this info being in a separate sheet, so far I have two formula's...both returning an incorrect result...

A question, if I may: my data, and a chart of the data, is in sheet 7 of a workbook. I have a macro that redraws the chart as the data changes. (I set some cells to generate random numbers on 'calculate' command in the macro) . The macro references sheet 7 and the data. For viewing purposes...