excel script

  1. D

    Assigning the Hour of the day to a variable

    So im creating a spin button that connects to a macro. The button would increment a cell by 1 based on the hour of the day and what day of the week it is. The code im using is: Sub OneClick() Dim strTime Dim LWeekday As Integer strTime = Time LWeekday = Weekday(vbUseSystemDayOfWeek)...
  2. D

    Move entire row to worksheet based on what is typed in NEED HELP THANK YOU!

    I am trying to move a whole row(B thru K of the row) to a different sheet when in column (B) on worksheet named Promises, you put either; PAID which would move the row to worksheet named Kept; BROKEN to worksheet named Broken; FOLLOW UP to worksheet named Followup. On the next blank line in...
  3. A

    Excel create new filed question

    Hi, I have 2 work sheets in the same file sheet one contains following info name, address, city, state, phone sheet 2 contains following information I downloaded form Australia Post webstite City, PostCode I want to add a extra column to sheet 1 that contains the post code for that city. I...

Watch MrExcel Video

This Week's Hot Topics

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
Top