work between sheets

  1. S

    Help on shift management

    Morning to everyone, I have some trouble to process the worked time of different workers in a month. Here you have a sample below : <colgroup><col><col span="13"><col><col><col span="20"><col></colgroup><tbody> Week from 12/01 to 12/03...
  2. F

    Macro needed for transferring rows to new worksheet

    Hi, I'm struggling with Macros abit and I am wondering if any of you people could help me? I have 2 worksheets "Sheet1" & "Sheet2" I have done a small table below just as an example. Worksheet one is the sheet that I fill in.. I need a Macro that automatically transfers a whole row once any...
  3. B

    First time working across sheets - Looking for some help and explanation

    Hi All, This is my first time working across sheets. I tried to copy the format of another program that worked across sheets. This is my code: Sub Search_Finder_Sheet() Dim sh_WC As Worksheet Dim sh_FS As Worksheet Set sh_WC = ActiveWorkbook.Sheets("Walls_OR_Columns") Set sh_FS =...
  4. 8

    Merge two worksheets in 1 WB with different column orders VBA

    Hi, I’m new here and I’ve been working on a macro that’s driving me crazy. So I have three worksheets in one workbook (A,B and C). I want to merge data from four columns across worksheets A and B onto worksheet C. However, worksheets A and B do not have my four columns listed in the same order...
  5. A

    Taking a value from another sheet and multiplying (cost x hours) and combining days, weeks months

    Hello everyone, I have tried to make a sheet which has Resource, Task, Rate (I'd like this to be on another sheet, as it does not help here and is a lot of repetition) Also, right now the columns for hours are based on weeks, but i'd like to do it by days and then collapse by weeks, and...
  6. A

    Move Entire Row to New Worksheet if Cell Contains Specific Text?

    Hi everyone, I am trying to write a macro that scans a selection of cells in one sheet and then cuts any rows from this sheet and pastes them into another sheet if the cell contains a particular text. As it stands I have two worksheets labelled "Data" and "Errors". On the Data worksheet I...
  7. D

    finding data between sheets

    Hi, I am working on a document and I need to do the following, If a value in sheet 1 exists on sheet 2, then i want the date of the value in sheet 2 (same row) to appear on a column in sheet 1 named date. how can you do this?

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