Overheard at work today...
They say that you should not dress for the job you have, but rather dress for the job you want.
So, here I am, sitting in Human Resources, dressed as Batman!
Hello Everyone,
I hope all are fine,
I will begin a new business "Women Dress Rental" and trying to make an excel project to manage my business but I don't have all the details I need.
Please let me know if you have any similar projects or rental system or if you know any website that helps...
<tbody>
LEEDS
DRESS
=SUMIF(INDIRECT("'[JAMIE SHEET LEEDS.xlsx]"&$C$5&"'!C$12:C$25"),$C9,INDIRECT("'[JAMIE SHEET LEEDS.xlsx]"&$C$5&"'!J$12:J$25"))
DENIM
SHIRT
</tbody>
<tbody></tbody>
Where JAMIE SHEET LEEDS is the data source which has multiple worksheets.
The INDIRECT function is...
Hi All,
Am trying to search entered value which is "item code" in another excel file and bring the item name and put into next column.
File1:
A B
1 Item Code: Item Name
2 1001 Red Dress
3 1002 Green Dress
File2...
I have an array of a sales report that was a .csv. I ran the text to columns and am left with this. I named the data set A2:F6 as "MYDATA"
<tbody>
A
B
C
D
E
F
1
Name
Item
Item
Item
Item
Item
2
Jane
Shirt
Leggings
Dress
3
Sallie
Dress
4
Edith
Leggings
Skirt
5
Cora...
Im looking to create count sheets from a list of data that I have. I have about 15,000 locations that have stock in and I want to create count sheets that have around 100 records in. Is there any way of doing a drop down menu and selecting a count sheet number and it brings up that...
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.