I get these catering summaries monthly, but each month the summaries' sheets are scrambled:
Column B:
Accounting Dept.
HR
Legal
Engineering
Sub Contractors
Guests
Operations
Maint.
Clinic
Admin.
Supply Chain
Etc.
Column C:
Figures (total number) of meals provided.
I do the job as the following...
When I get a report out of the system, “column a” should have all the names, instead it is first few rows name is in “column a”, then it is in “column b” then in “column c” and so on….
So I want to add a column before “column a” and in the “new column a” I want to get data from all the other...
I have a data like below
<tbody>
Dealer name
Location
12-06-2013
13-06-2013
14-06-2013
J.k Agencies
Ambur
No issues
No issues
Sri A.J & cext
Ambur
CC problem
MJ agencies
tambaram
not visited due to rain
not done
gt store
chennai...
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.