separate worksheets

  1. W

    move a row to another sheet and separate workbook based on cell value with button

    I discovered another thread close to something I am trying to do. Automatically move a row to another sheet based on cell value I am trying to do pretty much the same thing but with a button and with the copied data from columns A-M only going to 3 places at once, another sheet in the same...
  2. J

    Find text in one column = add "#, " to different column?

    Hello Excel experts... I thank you in advance! :-) I need to find words in column U, and if found, add comma-space-assigned number in column R (in same row). (without disturbing content already in column R. I've begun doing this manually.) Example of what I'm trying to do: (Would love to...
  3. T

    Macro won't copy data across worksheets

    Hello, I have been looking for an answer and I realise all that numerous types of script can be written for each action. I am producing a guestlist for a large event in which people across a network can access and then enter their details. If someone can help me with the script then I would...
  4. 4

    Copying Rows of Data to Separate Worksheets

    Hello, I am seeking some VBA help. On a monthly basis I download a transaction list with thousands of entries. In this situation I am only interested in what Column A contains. Column A holds the account number. There could be 1000 rows in which Column A would correspond to Account Number...
  5. C

    Create and output charts to separate worksheets.

    Hi all, I'm trying to create a chart for each line in an excel spreadsheet. I've got that part working and looking the way I want it to. Now my problem is to output each chart to a separate worksheet...and I'm stuck. Any help would be appreciated. Many Thanks, Bonnie Sub MacroCHARTIT()...
  6. A

    opening csv files in separate worksheets

    hello experts, i have this macro to open a number of csv files. Problem is that it opens all the files in one worksheet. Could you add a few lines to the macro to open them in separate worksheets of the excel file. i would be grateful for the help. Thanks :) Sub BulkImport()'' BulkImport...
  7. B

    Publish Multiple Worksheets as Separate HTML files from 1 workbook

    Is there any way to publish multiple worksheets in the same workbook to multiple HTML locations. So 1 Workbook. Sheets: Car- Published as Car.html Truck- Published as Truck.html Van- Published as Van.html Hopefully that makes sense.
  8. D

    Moving Rows to Separate Workseheets by Cell Value

    Good morning/afternoon! I see a lot of similar requests out there about moving rows based on a "Yes" value entered by the user. However, my quick search only showed data moved from one worksheet to another. I apologize for asking this question again, and might be able to work off another...
  9. R

    Copying data from second worksheet & copying formula

    I am building a worksheet that requires me to bring data from another worksheet. I have both worksheets open and to enter the data I am typing = and then switching to the other worksheet and entering on the required cell. This is bringing the data across correctly however when I attempt to...
  10. G

    Help creating a simple Macro similar to vlookup

    Hi Excel experts:) I have limited knowledge of Macros but would need one to help save on work load for something. I believe it should be straightforward enough, but then again I'm a novice! Basically I have a weekly report (in excel format) that collects stats on staff. Each week the file is...
  11. J

    Excel 2010 VBA Data Validation and Cell fill in

    Hello all, I have a workbook that contains two worksheets, RawData & Filtered. I have schedules listed by day, building, and duty on RawData and on my Filtered sheet I select Day and Building ($A$9 & $B$9) and have it populate who works for a particular selected day and selected...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top