new worksheet

Good Morning. I am a BASIC/BEGINNER excel user, no VBA/MACRO experience. I have a workbook that contains a master sheet of members who may be participating in various (and multiple) activities. I want to create a worksheet for each of the activities that automatically populates when a flag is...

Hi, I am looking for some code help with finding duplicates and moving them to a new spreadsheet. I am looking for duplicates between Sheet 1 and Sheet 2 Col (A) "policy num". I would like the duplicates to be moved to a new sheet (Sheet 3). I would like the new sheet with the duplicates to...

Hello. I am trying to copy two parts of a table, one section just having values and the other having formulas, to a new worksheet with the new worksheet taking on the name of the contents of cell A2. Cell A2 has the name of the the data set results of a drop-down result set run by a filter...

Hi all, Question: Anybody have an idea about the VBA code to use if I want to copy a column of data from one sheet in a workbook to paste as values in a master workbook? I wondered if it would be better to try some xml export...though I'm more confident with VBA. Any thoughts gratefully...

I have an Excel 2003 workbook with a sheet that has multiple data entries entered as groups of 8 rows and multiple columns. Each data entry corresponds with a real world location (Houston, St. Louis, or Spring House) and is denoted in one of the 8 rows by one of the following strings: HOU...

Hi, I have a worksheet containing a fixed column of data, say F36:F200. I would like a macro to copy this data and paste it into another worksheet. However, the beginning paste cell will change with each new addition of this columnar data. For example, this week the start paste cell will be...