pull data from multiple

I'm attempting to lookup blank column data from multiple sheets based on the cell value in a column named "NDC." I want the macro to be universal so that if I call it on a sheet that has the "NDC" column, it will pull data into all blank cells based on the NDC column's cell value. I think I have...

I'm attempting to pull blank column data from multiple sheets based on the cell value in a column named "NDC." I want the macro to be universal so that if I call it on a sheet that has the "NDC" column, it will pull data into all blank cells based on the NDC column's cell value. It's intended to...

Hello All, this is my first post and I am wondering how quick I will get a useful solution for my VBA newbie problem. I want to copy data from a single column which has the following location "F9:F26283", the data is to be retrieved from approximately 100 excelfiles with the same tab/sheet name...

I am working on a Classroom Files. Where i have many files containing report of each test like Test 1, Test 2, Test 3... I have to make a Master workbook that will contain the Mark Columns from All the Test Files I tried the PowerQuery ( I am very much new to PQ) but failed as it was...

Hello, Im new in VBA, and im searching for a script that would search in multiple sheets within one woorkbook, for specific text (specified in script itself) and paste it in a new sheet. for a descritpion: - multiple sheets (search in all of them) - skip new reference sheet + few others...

Hi all, I am very new to VBA and am stuck trying to edit code I already have written. Essentially, the code I have (below) was intended to loop through multiple files in a folder and pull certain data columns in from a specific worksheet. This worked fine for its original purpose, but was only...

I'm trying to write a Macro/VBA that will pull certain data from different sheets, ( Basically 12 Sheets a separate sheet for each Month ) into a different sheet. I'm not sure where to start. The Macro will need to be able to look through the rows in the 12 sheets and pull the necessary cells...

Hi everyone! To make it easy, I'll explain my issue now: I'm building a parts database on one tab in excel. Everything my company sells is going to be entered there...can I set up on another tab that when I enter a part number in Column A on Sheet 1, it finds it on Column A of Sheet 2 and will...

I can use spreadsheet programs on a fairly basic, functional level, but advanced features are still puzzling to me at times. Forgive the basic explanation below: I have a monthly workbook that tracks our agent's appointment progress each day with its own worksheet tab. Each day it tracks...

I have a master sheet containing customer data from 10 different spreadsheet saved in network folder for 10 outlets, all those sheets are same structure, now i am looking for excel formula to sync data from all 10 sheets to my master sheet, when ever i open the master sheet the data needs to be...