In the 2 attached files from Excel 2016, I want to compare the identifier column from clients 1 workbook, with the network login ID column in the clients 2 workbook and find which records are in both workbooks. The results can be put on a different sheet in either workbook if necessary, I just need to know where the data is the same.
Clients-1.xlsx
Clients-2.xlsx

I need to convert dates to fiscal year and fiscal quarter in Excel. The fiscal year ends Sept 30th. Thanks

Hi

I have a workbook that has 2 sheets and data in columns A-D what im trying to do is in column A on both sheets there is a unique 4 digit number of which is duplicated numerous times and then changed to a new one.

Im trying to somehow automate it so it sets up the filter in column A in both sheets and then selects the first number to filter it out in sheet 1 and then filter out same first number and data in sheet 2.

I then  need it to do an auto sum down column D of both sheets and if both total amounts agree (totals in sheet 1 & 2)  then thats fine leave it alone and move onto the next unique number and repeat function.  Dont worry about saving autosum.

If both total amounts dont agree I need it to compare data against each other in each sheet.  If the data's in sheet 1 but not sheet 2 then I need that row of data highlighting in sheet 1.

If all the data in sheet 1 & 2 are both present but still dont balance I then need it to look in sheet 2 only and look for duplicated entries. As far as I mean by duplicated entries all the data in columns A-D .

I then need any duplicated entries highlighted too.


Any Ideas?

How do you create an array formula in vba that returns the resultset of a sql query?

I have the sql/recordset part working already...

Looking to filter an Excel csv file that has 17 columns. 1 Column is where I'm looking for 'xxxx' and once found I want to export that finding along with the other 16 columns into a new excel sheet.

Never used powershell to filter excel and been researching online for a bit, but was hoping I can get some help.

Excel - I need to look at column  A and made a determination based on the value and place a word in Col  B.
If   A2  is less than  673  put "Short" in Col  B2
If   A2  is between  674 and 2016  put  "Mid"  in Col  B2
If   A2  is greater than  2017  put  "Long"  in Col  B2

need to adjust the COUNT HITS  RELATIVE   button
right now this button works when column A has 4 digits

but this file is being adjusted for 3 digits

I am adjusting column A of 4 digits to 3 digits and all its buttons in this file

Any question is welcome


29151977.xlsm

I am using Windows 10 and MS Office 365.   It's been a long time since I've used Excel, and forgot which function allows a specific cell value to change based on specific parameters in another cell.  For example, assume I have a spreadsheet that calculates an investment return on a land purchase - and the return is 5%.  I want to know how the land purchase price would have to change to make the return 10%.  Can you help??

Thanks,

Phil

adjust  in DTA 2 sheet  Count Hits button

29151908.xlsm

Hello experts,
I was wondering if someone can help me with a code to import/copy worksheets located in another workbook to active workbook based on userform.
In the userform I will specify the workbook path in which is reported worksheets and file name worksheets.

Checking and error handler:
1-If workbook path doesn't exists exit sub "Workbook path reported doesn't exist"
2-If worksheets reported doesn't exist exit sub "Worksheet doesn't exist"

If worksheets exist in active workbook they should be imported and renamed with (2) as it does excel when you copy a worksheet
It would be great if I can report multiple worksheets in the user form.
If you have questions please contact me.