Hi,
I have two workbooks. In Book 1, Cell C11, the formula is =C124.
In Cell C 124 of Book 1, the formula is = 'https:///personal/Test_com/Documents/Documents/[Source.xlsx]Sheet1'!$B$5
I then save and close both files.
When I open book 1, Cell C11 formula is replaced with...
Thank you for this.
I created a new excel work book, clicked on the developer tab, clicked on record macro and named and saved this file as Personal.xlsb
Then I opened the personal workbook again and clicked on the developer tab, VBA project and selected module 1 and pasted the code here.
I...
Apologies in advance and please excuse my stupidity. I am failing dismally at trying to do this.
What does designation mean?
I have attached the file. The other 3 files have a similar layout in that column A will either resolve as Show or Hide.
I have 4 workbooks. Column A of all 4 workbooks has a calculation which determines if the row should be hidden or not.
Each workbook has about 40 sheets.
I would like to record a personal macro that is able to run for all 4 workbooks so that I can hide the rows which need to be hidden. I...
Hi,
Please assist with a solution for creating a data validation list which has a data filter/search option.
Attached is my file. The data validation list is in column C.
Below is a standard data validation cell:
Thank you so much. This worked perfectly. Do you by any chance know how to do the following:
- i have used sumif to extract information in my balance sheet
- how do I reclassify credit accounts which are in debit to automatically post to accounts payables.
Hi Narayan,
Are you able to see my file? Cell O7 is linked to the cover page where it defines the period number and month. If O7=period 5, then the formula must sum B8:F8.
I am comparing the budget YTD vs Actual YTD. if I am in period 5 of the year, how do I get only the sum of the first 5 columns to display in the budget YTD column.
If N7=5, then sum B8:f8