cell ref in formulas

3 years ago as beginner VBA programmer I developed an application for the Food Bank: a "hand-out-list" for food-packages based on client-data in our "dossier"-system. Data extracted with Power Query and "enriched" with a VBA-script to the resulting "hand-out-list". List size about 730 rows...

Hi, I have a spreadsheet that I capture data in on a daily basis with a lot of different "Tables" which aren't formatted as actual tables. I then reference to select data to other tables in the sheet which are not in the same layout which is where my knowledge in excel is being tested. the...

Hello, first post here- I am trying to streamline the set up for a worksheet which I reference every day. Background info- The goal of the spreadsheet (Main) is to reference other worksheets (Project), which are stored on our local server, and pull data from those project worksheets to...

I'm working on updating some overly complex and inefficient formulas in an Excel workbook. When doing so, I noticed one of the formulas that calculates a check figure wasn't working. After looking at the problem I noticed that the lookup range in the VLOOKUP columns was starting two columns to...

Hi guys I'm a newbie but your forum has given me a lot of great resolutions. But I'm stuck and can't find anything that address my problem. First, macros and vba are not allowed in my office. I will use an example to describe the issue but a can't use the actual workbooks due to...