remarks

  1. C

    copy entire row based on cell vale

    Hi I have an inventory excel sheet with the following heads as under and file name is Cell Drying Spare List <colgroup><col width="64" style="width: 48pt;" span="4"> <col width="95" style="width: 71pt; mso-width-source: userset; mso-width-alt: 3474;"> <col width="64" style="width: 48pt;"...
  2. S

    Looping row data into column

    Hi, I have some repeated data from my database. Is it possible to make it in one row using macro. For example, for same data user, date login & remarks will loop at next column instead of next row. Could anyone assist me. Current data <tbody> firstname lastname id datelogin remarks tom...
  3. M

    Trim data

    <colgroup><col><col><col span="6"><col></colgroup><tbody> TRANSROAD - 01/06/18 JOB NO: WHARFAGE : USD APPROVED DIFF TSHS APPROVED DIFF REMARKS TR-0506 BALLEYA ENT - 6,694,028 6,694,028 TR-0446 S.F ENT -...
  4. M

    Pull not 38 and 39 data

    <colgroup><col><col><col span="6"><col></colgroup><tbody> TRANSROAD - 01/06/18 JOB NO: DELIVERY ORDER USD APPROVED DIFF TSHS APPROVED DIFF REMARKS TR-0381 TESCO - DIAMOND 85 85 - - $ 2000.00...
  5. J

    Calculating hours of late

    Looking for assistance in calculating how many hours late. <tbody> A B C IN OUT LATE 8:16 AM 5:00 AM L1 </tbody> In C, I would like the remarks L1 if late between 8:16 AM to 9:00AM, L2 if 9:01 AM to 10:00AM, L3 if 10:01 AM to 11AM and so on. I would like any help so each time I will...
  6. M

    Mark combined if.......

    <tbody> Date Group Code Remarks 06/02/2017 1 combined 01/01/2018 1 combined 03/02/2018 1 combined 01/05/2017 2 nope 01/06/2017 2 nope 01/08/2018 3 combined 09/09/2017 3 combined </tbody> hi guys is this possible, if the year of dates within the same group is different i want to...
  7. K

    Need Vba querry for user form

    Dear Experts, I have an excel sheet data and i want add remarks against emplyee code in remarks column. Data is as per below details. Column A - Emp_code (Already filled) Column B - Emp_Name (Already filled) Column C - Remarks (Need to fill by user form) Kindly help me out and give me user...
  8. A

    Combine unique data from a cell on another sheet with another cell on the current sheet without loosing its current data

    <tbody> Sheet 1 Remarks A1 ABC. </tbody> <tbody> Sheet 2 Remarks A1 ABC. EFG. HIJ </tbody> I have 2 sheets which are duplicates in data. Sheet 1 is the master sheet and the Sheet 2 is for someone to add any additional comments. Just say I have updated with more comments in the remarks...
  9. Y

    IF Formula Question

    Hi, Ive been for this report that i cant figure how to work. Can someone help me with a formula that will display expired remarks. For example i have =IF(k5>NOW,k5<<now,if(m5>NOW,IF(m5><now,if(o5>NOW,m5<NOW,IF(o5><now,if(s5>NOW,o5<NOW,IF(s5>NOW,s5<NOW))<now)) k5, m5, o5, s5 are the columns...

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