Search for a value in a range, copy only values of next three cells in row to last line of another sheet

N

nitinbali

New Member
Joined
Sep 12, 2011
Messages
1
I tried a lot by mixing various codes,, unable to get the work done... Please do help me guys... Thanks a ton..

I need to search for the value Diesel and copy next three cells to last line of another sheet. I need to copy only the values, as these are formula based cells.

My Excel sheet goes something like this.. (the sheet extends horizontally with similar fields)


Fuel Machine Meter reading Quantity Fuel Machine Meter reading Quantity
Diesel CAT 03 22 5 Diesel CAT 04 54 54
Petrol CAT 04 22 45 Hy Oil CAT 03 54 48
- - - - - - - -
- - - - - - - -
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
You must log in or register to reply here.

Similar threads

P
  • Question Question
Pick lines and copy depends to another cell sheet
Replies
2
Views
99
rowebca
rowebca
R
  • Question Question
Search a range for a specific color of rows, relocate those cells to another sheet, return previous sheet formatting to blank and sort secondary sheet
Replies
4
Views
371
Royalbloodi
R
T
  • Question Question
copy last column for each sheet and the ID for each adjacent cells
Replies
0
Views
142
tubrak
T
B
  • Question Question
Copy rows to another sheet based on checkbox and cell value
Replies
5
Views
5K
My Aswer Is This
My Aswer Is This
D
  • Question Question
Copy rows to a new workbook based on a date range of last three months from today()
Replies
8
Views
526
dandee14k
D

Forum statistics

Threads
1,224,600
Messages
6,179,836
Members
452,947
Latest member
Gerry_F

Share this page

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