davidepstein22
New Member
- Joined
- Aug 27, 2012
- Messages
- 27
Hi all,
I don't know if I found a MSFT bug, but let me explain my dilemma and I would appreciate your comments/suggestion
1. My spreadsheet reads about 25-sales files using Power Query and places the data in a new sheet. This works correctly
2. I summarize #1 using the unique function to calculate the total units sold by model number. This works correctly.
3. My VBA reads the new month's data and enters the data into my Sales table (a formal Excel table). This works correctly.
4. The VBA code attempts to convert the formulas into values in the Units Sold column for the new rows (cells), but it always returns "0" (over writing the actual values). I expected a simple copy | paste values would work, but it does not. I even tried copying the values to a new workbook and then pasting them back to the desired sheet, but it did not work, nor many other approaches.
I am convinced there is a bug or table behavior is causing to occur, but I can't identify the cause. I would appreciate your help.
Thanks,
Dave
I don't know if I found a MSFT bug, but let me explain my dilemma and I would appreciate your comments/suggestion
1. My spreadsheet reads about 25-sales files using Power Query and places the data in a new sheet. This works correctly
2. I summarize #1 using the unique function to calculate the total units sold by model number. This works correctly.
3. My VBA reads the new month's data and enters the data into my Sales table (a formal Excel table). This works correctly.
4. The VBA code attempts to convert the formulas into values in the Units Sold column for the new rows (cells), but it always returns "0" (over writing the actual values). I expected a simple copy | paste values would work, but it does not. I even tried copying the values to a new workbook and then pasting them back to the desired sheet, but it did not work, nor many other approaches.
I am convinced there is a bug or table behavior is causing to occur, but I can't identify the cause. I would appreciate your help.
Thanks,
Dave