Creating a Delivery Note

R

Respect1001

New Member
Joined
Jan 30, 2014
Messages
1
I'm trying to create one consolidated list of material into a delivery list. I have a number of sheets with stock data in. Ie Description (A), Qty (B), Cost (C). up to 1000 rows. I would like to create a new sheet just with the data from rows with a qty in the qty cell (Ignoring blanks), but also taking over Description coloum as well. Any help is much appreciated!!!!
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
You must log in or register to reply here.

Similar threads

J
  • Question
List/Chart Help
Replies
0
Views
132
jmaxwell85
J
L
  • Question
Hover Function in Excel Similar to PowerBI
Replies
0
Views
246
Lali2023
L
B
  • Question
Need formula help
2
Replies
10
Views
459
NateSC
NateSC
J
  • Question
TURN CELL CONTENT INTER HYPERLINK FOR SAME NAMED SHEET
Replies
3
Views
119
JuicyMusic
J
P
  • Question
Consolodate data to matching columns
Replies
0
Views
293
PippaThePointer
P

Forum statistics

Threads
1,214,827
Messages
6,121,817
Members
449,049
Latest member
cybersurfer5000

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