User Profile
Daibear
Copper Contributor
Joined Jan 13, 2022
User Widgets
Recent Discussions
Re: Need a separate sheet to return total income for each month
Hi, Thank you for prompt reply. Unfortunately, currently returning a 0 value for every month. =SUMIFS(Table22[Income - Vatable], Table22[Date], ">="&A2, Table22[Date], "<"&EDATE(A2,1)) Table date is 01-Jan-22 Date in A2 is MMM Anything else I'm missing?1.4KViews0likes4CommentsNeed a separate sheet to return total income for each month
Hi, I'm struggling with what I thought would be a simple Sumifs function. Named sheet "income 2022" has the date in column A and the income in column G. All this data is in a table called "table22". In a separate sheet, "monthly income" column A is Jan through to Dec and I want column B to return the total income for each month from sheet above. Seems to be struggling with whether I should be using EDate as suggested elsewhere or whether it should be another function. Thank you for any help.Solved1.5KViews0likes6CommentsError from Word to Excel using Merge. Field showing "0" instead of text
Hi All, I am having trouble with one particular field from my excel spreadsheet to a word merge. Using Office 365 on desktops. The files are held in dropbox accessed by 3 users on different desktops. There are 16 fields in total A1:-P1. I am having difficulty with the last field - P1. For some reason, that is coming up as "0" on the word document instead of showing the text that is shown on the Excel sheet. The text is 56 words long with a postal address included within it. This text is pulled from Sheet 2 via a XLOOKUP formula. Is there any reason why "0" is showing up on my form? This was working previously and no obvious changes have been made. All other fields work fine, just this one. Any help is much appreciated.1.4KViews0likes0Commentsmacro button to open word document and use data.
Hi all, PC using Office 365. I want to have 4 or 5 macro buttons that open various word documents and automatically have the data from the sheet available (just edit recipients list). Currently have the buttons set up but when the word document opens I then have to go into select recipients and use existing list to find the data source. I assume this is a visual basic rework but I would have no idea how to do that. I know this is vague but any help to put me into the right direction would be much appreciated.645Views0likes0CommentsSetting up data for a word merge
Hi All, I've set up a sheet for which a clients information gets entered and this is then merged onto various forms in word. I need to add a company and company relevant details (1 of 4 to choose) on to the same row as the client information. What i want is to simply select the company from a list (data validation?) and then the remaining information is automatically input next to it. So far I have set up a table on sheet 2 with the list of the 4 companies in A2-A5. There are then 3 more columns of data for each company that needs to be transferred over. The company selection on sheet 1 is column L with the remaining company info to automatically go into M, N, O. When selecting the company from the drop down list, is there a way the remaining info automatically put into the cells next to it? ThanksSolved1.2KViews0likes3Comments
Recent Blog Articles
No content to show