Search results for query: *

I have an excel file with 3 columns. They are date, units sold and the sum of units sold. Column E has Sale method. Cell "E2" would specify the sale method. There are 2 kinds of Sale methods. One is "Regular" and the other is "Deferred". Regular Sale method is as follows. The units are always...

Hi Please find the excel file pivot.xlsx attached. It has a raw data by month and also the final pivot format that I am expected. I had highlighted the expected pivot values in yellow. Please provide...

I am using Excel 2010. I have a base table which has month, gender and cost columns. Month is like Jan, Feb, Mar... Dec. Gender is Male or Female. I need to create a pivot table, which can get the sum of cost by Males and Females for each month. Then again, the Female cost should be subtracted...

I am using Excel 2007. Using Excel VBA, I am supposed to go a specific Web Site's HOME page. On that web HOME page there are a lot of loans which are in the form of Hyper links. If I can click any Hyperlink, it will take to a web page that is specific to that loan's web page. Hence, If there...

I am using MS Access 2007. I have a table which has attachment field in it. The field names are 1) Record_ID 2) Attachment Record_ID contains the unique number for a record. It is a numeric value. Attachment may be any file that is inserted into the table for that Record_ID. It might be a...

I am using Excel 2007. In an Excel Workbook, On one of the Tabs, I have an Excel Chart. I wish to place this chart on the Home page of the corportate Sharepoint web site. How can I publish my chart on Sharepoint? This chart on the sharepoint should always reflect the latest data from the Excel...