spreadsheets

Afternoon, I am looking to link various cells from multiple spreadsheets to a master spreadsheet automatically without overwriting the previous data. The purpose of this spreadsheet is to create a master log of work done for all sites, the individual spreadsheets are basically a time sheet...

I'm wondering if there is an easy Visual Basic program that can do this: I have multiple spreadsheets (any where from 1 to 300 on any given day). For each of these spreadsheets I need to run the same Macro and then save the result in a specific folder. Is there a way to do this in a batch where...

Hello I am on MAC right now, I have 51 spreadsheets with 50 rows and about 25 columns each one, I tried to consolidate but there are many errors when there is a blank column, cell or row. Is there a way to just copy in sequence the lines data from A1 to Z50 from all spreadsheets to one? Any...

Hi there, I have 2 spreadsheets (MS Office 2016), one which has 4000 lines of data (component part numbers) and an updated one which has 4500 lines of data. Because of the type of work I am doing it was reasonable for me to assume that the original 4000 items were included in the new...

Hey community! I've come to the limit again that I have to use VBA. Unfortunately, my abilities with VBA are exhausted. I have a file that should overwrite selected tables in new or old Excel spreadsheets after updating all PowerQuery connections. So I have TblTotal. This has a total of 10...

Hello, I have inherited and frankenstein'd a schedule making spreadsheet. It has a mixed chart that has milestones, only, i can't seem to figure out why my milestone list won't populate the chart with the milestone names on the labels. I even copied in the original spreadsheet's chart and...

I have a Lenovo laptop, and I find myself inadvertently inserting characters into my spreadsheets. I have already disabled the trackpad, and use only the red dot in the middle of the keyboard for moving the cursor around, but I still find all types of unwanted characters. I have Undo in the...

Hello to all, need help getting a 0 to go away when linking a excel spreadsheet to another spreadsheet.

Hi, I have 360 spreadsheets all of them with 2 rows (Heading and data) and 80 columns. All of the spreadsheets have different names. What I am trying to do is to insert a column in column A give a name (User ID) and add a consecutive number to each of them i.e. ID1, ID2, etc. I can open one by...

Hi there, I have been using the get and transform function in excel for a while. I have a workbook with a lot of individual reports. I have connected them using get and transform, but when I replaced the data with current month's data, for some reason my merged table that is connected to all...

Hello I am trying to create a macro that can count how many times a stock shows up during a particular day. It needs to do a few things: 1. Filter for prior day or most recent date in column N 2. Filter column H for Volatility; its what the stock has been categorized as 3. Remove duplicates...

Lately I have been experiencing an issue with my formula bar that doesn't appear to have been picked up or questioned anywhere else. Essentially what is happening is that on some spreadsheets the insert function button and cell number/coordinate box are missing and the formula bar extends the...

I am using Powerquery in Excel 2016 (Office 365) I have a bunch of Excel Spreadsheets (daily spreadsheets of run time) saved in a network folder and I have PQ connected to that folder and combining all the spreadsheets into one large table. The columns of data are the run date, item name, sub...

Excel 2016 MSO (16.0.4639.1000) 32-bit This is a macro enabled workbook with several modules in Visual Basic. Also, every spreadsheet has Worksheet_BeforeDoubleClick sub routines. One spreadsheet is "Summary Report". "Summary Report reads values (via if statements and simple = formulas) on...

We receive monthly Excel files from a service provider. When one of these files is open at the same time as our own spreadsheets we cannot insert or delete rows in our spreadsheets. My first inclination was rogue code, but I saved a copy of their file and removed all code and our row...

Can someone help me with VBA Code for doing a Cntrl+Shift+Home. I want to be able to do select content from anywhere in my last column to first cell in spreadsheet because my my macro deals with spreadsheets that have the same number of columns/columns but have different number of rows. Thanks.

Need VBA to copy the last row data from various spreadsheets and also create Hyperlink for file name to open file instantly.

Hopefully this isn’t too confusing… I have two spreadsheets containing several thousand rows each and need to compare the two. The first (AV) is from our internal database and the second is from an online source (XYZ). AV contains: Name, Email, Phone, Status XYZ contains: Name, Email...

I’m still working on my workbook for the school I oversee. Iam looking for some more help though as I’ve hit an end to what I know and I’mlooking for ways I can make the operations easier for whoever comes in nextafter me. So far I have multiple spreadsheets, adobe, and word documents that Imake...

Hi All - Here's the issue: we have 5 large spreadsheets that link to one master spreadsheets also large. All 6 sheets and the folder they reside in are named with the 2 digit year. We prepare the set of 6 sheets each year with what seems to be a zillion links each pointing to a file that has...