sheets

Hi all, I'm trying to create a single Excel file that links to other files that reference their own sheets. This would be simple enough I think except that I am trying to have all the information contained in one file to show the amount of working. So 'New file' would have sheet links to 'File...

I created a calendar, I would like the days of the calendar to be formatted based on the profit or loss for that day. I figured I could have a query table that takes all the data from my main dataset and groups/sums the P&L by day, and then reference this table in a formula to format the...

Hi, i've got a code that works - kind of. It does run, and it runs at a good speed. Only problem is that it's not kicking the right rows... High level explanation: I've got sheet A with all my data, it goes to sheet B to see what qualifier to use and then finds it in sheet C which ones have...

Hi! I just joined this forum out of desperation haha. I'm trying to link my Google Sheet to Excel Mac (latest version) and it limits the import to 100 rows, plus a message about "Finance Data Listing and Disclaimers." The Sheet I am trying to query has no formula related to anything financial...

Hello, I am very new to excel and VBA. I am trying to: -Have a button for each row in a sheet called "sheet one". -On click for one of these buttons, it copies 10 specific cells from the row (say J, H, I, M and L for a given row), -Putting them in a new entry in a different sheet "sheet two"...

Hi everyone, I'm searching the web but I only found one code that kind of works but I need to make it more complex. Let me explain. My issue is that I have an Excel sheet with multiple worksheets, which all contain the same kind of information but are copied weekly by me. So every week, I will...

Hi!, I´m new here I have a little macro. The problem is that i´m trying to copy a range of another sheet on the same sheet but i think that i have a error syntaxis cuz the macro don´t runs. These are the bad guys: Worksheets("plan").Range("G4:K7").Copy: Worksheets("plan").Range(Cells(j, 7)...

Hi, I'm currently looking at this excel sheet which allows you to choose a project and prints the booking reference. I do not understand how the booking reference is found as it is received from a sheet called Data as shown, this is not installed on my system nor in any of the sheets in this...

Hello, I have an issue, I need to: Ask the user for the highest and lowest possible values of the random numbers Ask the user how many rows and how many columns she/he wants to create Insert a new sheet into the workbook with the name "‘RandomNumbers"’ and fill this sheet with the appropriate...

Hello All, I got 5 sheets with different tabcolors. The tab of a sheet becomes red when a certain value on the sheet isn't met. When it is, it becomes green. The only sheets I want to select as an array are the green sheets. How can I do this? For example: Sheet 1 tab color = Green Sheet 2 tab...

Dear Everyone! I want to ask your help. I have read all about this forum, but the solutions i've found, not work for me in google sheets. My wife leads a Development Centre that helps little children to develop motor skills. At the beginning of a new month, she has to send a report to the...

EMPLOYEE NAME SURVEYS POSITIVE SURVEYS NEGATIVE SURVEYS CURRENT PERCENTAGE TARGET PERCENTAGE POSITIVE SURVEYS NEEDED E1 42 50% 75% If positive surveys vs negative surveys count as 9 positive surveys is equal to or gets canceled by 1 negative survey. With the given data above, how many...

Hello guys! Firstly, feel free to save time and jump straight to the TLDR bold section below, then read the rest of this long post only if more context is needed to help. This is probably a super easy problem for most of you, so trying to respect your time here, but also include context incase...

I am new to spreadsheets and have no training. My knowledge is very limited. Screenshots of the spreadsheet I’m creating are attached. I am attempting to total all miles and fuel by state on sheet “Quarterly IFTA Report” for all the sheets between the sheets “Start” and “Stop” Additional sheets...

Hello all, I'm trying to improve the inventory management process at work, currently we're tracking everything through manual input (handwritten) using a form and then we put any relevant information on a sticky note and post it to the box. These boxes come in from numerous different places and...

Hi! Im new on excel and i have no idea on how to use it at all. I wanted to search between two sheets, which I managed to do, but then I would like to search on the second sheet, 'C' column every coincidence with the H2 field on the first sheet. Every time it finds one coincidende (so for...

For example, I have a workbook I use to enter data from my daily work deposits. Each sheet n the workbook has a single days worth of data. We run on a period schedule of 4 weeks. I would like to be able to create a sheet called "Period 1" and hide all of the date sheets within the specified...

Hello everybody, I am currently having some problems with my excel spreadsheet. In short, I have a list of materials in my "Order form" sheet 1 and I have all the hard data in a hidden sheet called "Products" (sheet 2). Currently, I have just set the fields in my "Order form" sheet = the...

Hello, I am trying to rebuild and hopefully automate a very manual report that pulls specific sets of data that's housed in several different sheets in one workbook, onto a corresponding community sheet in a separate workbook. The community data I need is currently pulled by one report and...

Hi everyone! Let's say there is information on Sheet1 consisting of 3 columns. When I write one of the information in the third column in a cell on Sheet2, I want the other two data in the row of the information to be printed. I would be glad if you help. ex: Get the name, age and citizenship...